Dear Friends,
I am wanting to create a VB script that will take a number (in general format) of two or three digits, convert it to text, then make sure that there are enough zeros preceeding the number to make exactly 6 digits. Examples of the initial number (before the macro is run) and the final number (after it is run):
initial number: 34 (general format)
final number: 000034 (in text format)
initial number: 345 (general format)
final number: 000345 (in text format)
Can anyone help?
Thank you so much,
Mike
Bookmarks