Excel Experts

Posted By Message

DRMom
Two in Blue

Member since 5/05

20223 total posts

Name:
Melissa

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

Christine
2nd verse same as the 1st

Member since 5/05

15287 total posts

Name:

Re: Excel Experts

You can format those cells for a zip code...

Format Cells
-Number
-Special
-Select Zip Code

Posted 7/9/08 12:01 PM
 

TTCbaby
Twin mommies are twice as nice

Member since 4/08

1861 total posts

Name:
J

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
 

statusquoscreenname
LIF Adolescent

Member since 9/07

885 total posts

Name:
Victoria

Re: Excel Experts

Right Click > Format Cells

Go to the Number Tab and select "special". There is one set up for zip codes, if you use it the leading zeroes won't get truncated.

HTH

Posted 7/9/08 12:03 PM
 

pinkandblue
Our family is complete, maybe

Member since 9/05

32436 total posts

Name:
Stephanie

Re: Excel Experts

or go into the cell and add a ' in front of the zero......it will work that way too Chat Icon

Posted 7/9/08 1:11 PM
 

DRMom
Two in Blue

Member since 5/05

20223 total posts

Name:
Melissa

Re: Excel Experts

Thank you!Chat Icon

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