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