| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert 9 digit zipcodes to 5 digits?
I have an EXCEL 2003 spreadsheet containing a column with zip codes in this
format: 12345-6789 How can I convert these zip codes to a column that just has the first five digits, that is: 12345 ? I will appreciate advice. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting the first 3 digits out of 6 digit cells? | Excel Worksheet Functions | |||
| Mod 10 & 11 | Excel Worksheet Functions | |||
| How do you display 16 digit numbers in excel ? (it keeps convert. | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| I have a col. with 6 digit nos to convert to 3 cols of 2 digits | Excel Discussion (Misc queries) | |||
Threaded Mode
