formatting zip codes in excel
 

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!

formatting zip codes in excel
 

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"
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!