Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FormatCellsSpecialZip Code
Every day I receive a list of Zip Codes covering Sales Leads. The as-received
format includes regular 5 digit zips, 5+4 zips, and 5 digit zips with the leading zeros omitted, but I need to change it to 5 digit to process further. Routinely, I use the command "FormatCellsSpecialZip Code" to add the leading zeros back. But the command seems unable to convert a '5+4' format to a simple 5 digit format, and I end up having to delete the hypen and the last 4 digits manually. Am I missing a trick? Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to detect symbol/special character code | Excel Discussion (Misc queries) | |||
Format Cells by code | Excel Worksheet Functions | |||
Format cells for special characters | New Users to Excel | |||
Format cells for special characters | New Users to Excel | |||
Special Code | New Users to Excel |