0's in front

[Alfonzo]

Hello,

This is my first post so I hope I am in the right section.

I am having trouble with some Zip codes that start with a 0.

When I save the document the 0's are removed, is there any way to keep this from happening?

[Richard Schollar]

Hi

How are you saving the documents? Sounds like you are saving as a csv format (rather than as an excel file)? If so, try opening the file in Notepad (rather than Excel) to confirm the leading 0s are still present.

Richard

[Alfonzo]

yes they are .csv documents, I need them like this to open them in UPS Worldship.

For now the workaround I have been going through is to reopen them replace the 0's and save them again to then open them in UPS Worldship, which can read the zero's until I reopen the excel file.

I did open it in notepad and the 0's were in there.

[Alfonzo]

Is there any way to keep this from happening in a .csv file?

[Kylee]

I know this is late, but my first thought is how is the column formatted? If you can change the format of the column to "text" instead of number/accounting/etc., then your zero's will remain. That's pretty much the extent of my Excel knowledge. LoL
~Ky

[Andrew-Mark]

Pls ignore, I was wrong

[Alfonzo]

yea its formatted to be a zip code yet it still cuts off the 0's in the front, i don't get it.