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
|