dropped zeros

[mac_collector]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

Zeros are dropped in a number sequence beginning with zero. I have a list that contains zip codes beginning with zero. When I imported data, I made sure that I imported as text. After import, that column showed up as general. I changed the column back to text, manually added back all the zeros, and saved and closed. When I opened the file again, that column was back to general and all my zeros disappeared. What am I doing wrong?

 

[macropod]

Hi,

Did you try formatting the cells with the zip code format?