View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
simon.guertin simon.guertin is offline
external usenet poster
 
Posts: 1
Default Modifiying a text number ( 12345 ) to have exactly 6 digit with a 0 in front

Hi, How can I parse my excell column that contains numbers
(I changed them to be text) I want to put zeros in front
so the number has 6 digit. the number may have 3 4 or 5
digit so I need to fill 0 in front so it is 001234
thank you

Simon