Leading zeroes in ZIP field
 

How do I stop losing the leading zero in a ZIP code field in a .csv file?

Leading zeroes in ZIP field
 

Hi Kate,

You could format the cells with the zip code format (Format|Cells|Special).

Cheers

--
macropod
[MVP - Microsoft Word]


"KateB" wrote in message
...
How do I stop losing the leading zero in a ZIP code field in a .csv file?

Leading zeroes in ZIP field
 

If you see the leading 0's in excel before you save the data in a .csv file,
then the 0's are still there.

But don't open the .csv file in excel to check it. (That's the part that's
losing the leading 0's.)

Just open that .csv file in Notepad or some other text editor.

KateB wrote:

How do I stop losing the leading zero in a ZIP code field in a .csv file?

--

Dave Peterson