How about:

[vba]MsgBox "0" & CStr(123456)[/vba]

HTH,