| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying SSNs to new format
I have thousands of SSNs that imported to my Excel 2002 document without
formatting. I would like to change them from "123456789" to "123-45-6789." I researched this, and other postings here instructed me to create a new column, format the new cells to "Special / Social Security Number," then copy the unformatted cells using Paste Special and choose Add. This doesn't work. The format still says it's in SSN format, but the numbers are still 123456789. Please, what am I doing wrong?!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a format that has been conditionally formated | Excel Discussion (Misc queries) | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| Copying a date format | Excel Discussion (Misc queries) | |||
| Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
| Copying a conditional format | Excel Worksheet Functions | |||
Threaded Mode
