numbers stored as format - leading zeros - save as csv

[MikeL]

Hi, in cell F2, i have 15 formatted as '00015' based on text(e2,"00000"). I need to save as csv but lose leading zeros and it now says '15' in the csv. How to save as csv as '00015' a 5 digit text?

 

[TryingToLearn]

format the cell as custom 00000

 

[MikeL]

format the cell as custom 00000

Didn't work. format as not changing underlying to text when opening in csv

 

[TryingToLearn]

Worked for me. Try placing a ' before the data in the cell before saving. That should force it to be text.

 

[MikeL]

I will clarify. If I use custom format and open the csv in a text editor, i see the leading zeros. but I need to open the csv in Excel or other databases and lose the leading zero.

 

[Peter_SSs]

Try this:
In Excel go to File -> Options -> Data -> Automatic Data Conversion and turn off "Remove leading zeros and convert to a number" -> OK

 

[MikeL]

Try this:
In Excel go to File -> Options -> Data -> Automatic Data Conversion and turn off "Remove leading zeros and convert to a number" -> OK

I dont see this option in 365

 

[Peter_SSs]

I dont see this option in 365

I am also using 365. The option is here: (I have that setting 'on' but you would have it 'off')