| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting different zip code types within a column
Never mind! I wrote the formula wrong! Thanks! That was perfect and easy!
"Dave Peterson" wrote: Try a custom format. Format|Cells|Number tab|Custom category [99999]00000-0000;00000 prizm wrote: In Excel, with the .csv file extension, we have a column of zip codes that are set up differently for each record. For an example, we will have 6037, 60371022 and 25463. If we highlight the whole column and select "zipcode", the 6037 becomes 06037 (like it should), the 25463 stays the same, but the 60371022 doesn't get the leading zero. If we use the zip plus 4, then the 6037 becomes 06037-0000 which is also incorrect. Is there a way to format all three types at the same time without doing too much manual manipulation? Please advise. Thanks -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| Mixed Column Types in One Chart | Charts and Charting in Excel | |||
| Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
| Sun IF two data types are the same in a single column | Excel Discussion (Misc queries) | |||
| How do I mix column chart types? | Charts and Charting in Excel | |||
Threaded Mode
