Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to convert a series of numbers
I have received an EXCEL 2003 worksheet with a column that contains many zip
codes, improperly formatted. The cells contain, for instance: 10751746, but I want 01075 10271234, but I want 01027 10359999, but I want 01035 How can I convert the numbers above to give me the numbers I want as indicated above? I will appreciate advice. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
extract numbers, convert to date | Excel Discussion (Misc queries) | |||
Convert to Numbers | Excel Worksheet Functions | |||
Convert text to numbers | Excel Discussion (Misc queries) | |||
How to convert Numbers to text | Excel Worksheet Functions |