Leading Zeros

[LisaMass1970]

Hello, I'm using Excel 2016. I need to change numbers in the coulmns to include leading zeros. So 1 will become 001, 2 will become 002, etc. Then I want to save it as a txt file. I changed my column to text and made sure in the number section it says text. When I do a replace from 1 to 001, it shows how many changes but doesn't save it or show the changes in the sheet. Any ideas what I'm missing?

Thanks

 

[mole999]

think you need to have the number as text '0001 from the apostrophe

 

[LisaMass1970]

think you need to have the number as text '0001 from the apostrophe

Thank you!

 

[Eric W]

You could also just use a custom format of 000 and when you save the file as a CSV, it saves the display version of the value.