Excel Experts
| Posted By | Message |
|---|---|
|
Excel Experts I am doing a spreadsheet with a separate line for zip codes-but any zip that starts with zero the zero won't show up....how do I fix this? |
|
Posted 7/9/08 11:59 AM
|
|
|
Long Island Weddings
Long Island's Largest Bridal Resource
| |
|
Re: Excel Experts You can format those cells for a zip code... |
|
Posted 7/9/08 12:01 PM
|
|
|
Re: Excel Experts format the row and choose the category "special" on the format menu and then click zip code. The zero shoud show up then. |
|
Posted 7/9/08 12:01 PM
|
|
|
Re: Excel Experts Right Click > Format Cells |
|
Posted 7/9/08 12:03 PM
|
|
|
Re: Excel Experts or go into the cell and add a ' in front of the zero......it will work that way too |
|
Posted 7/9/08 1:11 PM
|
|
|
Re: Excel Experts Thank you! |
|
Posted 7/9/08 1:31 PM
|
|
Potentially Related Topics:
| Topic | Posted By | Started | Replies | Forum |
|---|---|---|---|---|
| calling all the IF experts/researchers/scientists | rose825 | 3/13/06 | 21 | Infertility |
| chart experts I have a question... | jeandan | 3/13/06 | 6 | TTC |
| experts needed... | jeandan | 3/8/06 | 8 | TTC |
| Celebrity Experts- Can you please tell me who this is | justthe4ofus | 2/21/06 | 43 | Families Helping Families ™ |
| Temp Experts.. Opinions Wanted.. | justme1 | 2/5/06 | 6 | TTC |
| Question for the Exercise Experts! | mrswask | 1/30/06 | 12 | Diet & Fitness |







