formatting zip codes in excel

[Guest]

I am outputting data from a datalist in c# to an excel document. One of my
columns contains zip codes, some that are 9 digits, and some that are only 5.
If I use Number Format to format the zip codes like this:

"#####-####"

then the zip codes with only 5 digits show up like this, for example: 1-2345
instead of 12345-

Is there a way that I can tell it to format the number from the left, rather
than from the right?

Thanks!

 

[Jim Cone]

If the data are really numbers, try this custom format...

[>99999]00000-0000;00000
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"elfenland" <[email protected]>
wrote in message
I am outputting data from a datalist in c# to an excel document. One of my
columns contains zip codes, some that are 9 digits, and some that are only 5.
If I use Number Format to format the zip codes like this:
"#####-####"
then the zip codes with only 5 digits show up like this, for example: 1-2345
instead of 12345-
Is there a way that I can tell it to format the number from the left, rather
than from the right?
Thanks!