View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dlb1228
 
Posts: n/a
Default put 0 in front of number

i have a field that has a number in it for example
100
115
116
12

i want these to always be 4 digits and put zeros in front of the number
how can i do this