Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel and zip codes | Excel Discussion (Misc queries) | |||
Zip codes are not formatting | Excel Discussion (Misc queries) | |||
Zip Codes from excel to .csv | New Users to Excel | |||
Bar Codes in Excel | Excel Discussion (Misc queries) | |||
Formatting Codes for header and footer | Excel Programming |