leading 0 on zip code dropped in excel

C

Connie

I am not hand keying. I have exported the file from an
accounting package that is used in UNIX. Is there a way
to ad an apostrophe and the zeros so that all the data in
the zip field is formated as zip code when you look at it
in the formula bar? The formula bar showes without zeros
even after formatting with zeros.
 
D

Dave Peterson

How about just formatting the cell(s) as Zip (or Zip+4).

They'll look pretty on the worksheet -- not quite so in the formula bar.
 
Top