leading zeros help!

When I input zip codes, and 0 is the first number in the cell, numbers automatically deletes the 0. For example if the zip code is 07733, when i hit enter or move to the next cell is becomes, 7733. How do I change this setting?

Mac OS X (10.4.11)

Posted on Jul 14, 2008 8:00 PM

16 replies

pw1840

Level 3

860 points

Jul 14, 2008 8:34 PM in response to witchycb

witchycb,

Select the column containing the ZIP codes, then activate Inspector > Cells and set the cell format to "Text".

pw

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

leading zeros help!

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up