Home |
Search |
Today's Posts |
#1
|
|||
|
|||
social security sorting
I am having problems with sorting social secuirity/tax id numbers that were
dropped into excel from several different sources. Some of the ss/tax id numbers have dashes and some do not. Some of the ss/tax id numbers are missing leading zero's. I am not able to change all of them into a text format. How can I formatt them all so they will sort properly? Thanks for any assistance out there. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
How do I insert hypens in existing column representing social sec. | Excel Discussion (Misc queries) | |||
Setting macro security level to "low" permanently? | Excel Discussion (Misc queries) | |||
sorting question | Excel Discussion (Misc queries) |