View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Staten42 Staten42 is offline
external usenet poster
 
Posts: 5
Default Adding 0 to the front of a number

I have a data set that has a 5 digit id field with the first id being 00001.
How can I add the zeros i need to a similar data set that doesn't currently
have the zeros in front to make the 5 digit character?

Any help would be awesome!