number format

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

Hi
I am trying to enter data onto a worksheet from a slide
bar on a userform. I need the number to be in a 5
character format i.e. if 5 is entered 00005 is displayed.
I can do this by formating to a zip code. The problem
occurs when I save as a text file, 00005 becomes 5 again.
Is there some code I could write which changes 5 to 00005?
Thanks
Jo
 
You need to set a custom format. Select cells, right
click, format cells, number, custom. In the "type" box
eneter 0000# that will give you the format you are
looking for........
 
Back
Top