sql server reporting services: How to make Zip Code 5 characters and not 4 in Excell -- sql server reporting services

How to make Zip Code 5 characters and not 4 in Excell

Sorcerdon
12/15/2005 2:43:17 PM

sql server reporting services: Is there a way to get 5 character zip code in excell without making it
into a TEXT?
ex:
zip code: 1024
I want it : 01024

BUT (It's a big but) I dont want it to be text - I need it to stay a
numercial # so that excell can read it as a zip code.

Is this possible?

Re: How to make Zip Code 5 characters and not 4 in Excell

Carol
12/15/2005 3:06:20 PM

When you format the cells, look under Special - there is a ZipCode
format

[quoted text, click to view]

Re: How to make Zip Code 5 characters and not 4 in Excell

Sorcerdon
12/16/2005 10:35:13 AM

Where is this located?

In the formating all I have is:
Default
Number
Date
Time
Percentage
Currency

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.