How are you saving the file? Is it a .csv? If so, the zero's should be
saved. When you open a .csv in excel it automatically strips the zero's from
VIEW, but they are still on the file. Try opening with a text editor
(notepad), and you will see the zero's.

If you are saving as an excel sheet (.xls), the formatting should be saved
as well.

If you want to hard code the 0's to the front of your zip codes, use the
following formula in a helper column (assuming your data starts in cell A1),
and then do a "Paste Special"-Values on the range to get rid of the formula.

=REPT("0",5-LEN(A1))&A1


--
Regards,
Dave


"Ofelia" wrote:

I have a zip code that begins with a zero. I try to format the cell and it
appears to work, but it does not show the zero in the formula bar. Then I'll
save it but when I reopen the worksheet it does not save it. Is there some
other way of doing this? Please Help!- Thanks