Hello VBAExpressers,
I need to convert a number to a string. VBA Cstr function would normally handle this chore. However, my case is a bit more complex. I want the converted string to have a leading zero eg: from 123456 (number) to 0123456 (string).
My first attempt to test the output (see the following script) doesn?t work out.
Any idea? Will appreciate your help.Msgbox IsNumeric(Cstr(?0? & 123456))
Thanks in advance & regards
kp