| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Remove formatting from SSN
I exported some data from an Access database. The Social Security Numbers
are in this format: 123-45-6789. I would like to change them all to 123456789. I've tried creating a Custom Format and formatting the cells, but nothing changed. Tried setting the format of a new column, then cutting and pasting or Paste Special into the new cells, but it keeps the old formatting. Is there an answer? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove automatic formatting of new columns in Excel? | Excel Discussion (Misc queries) | |||
| Clean does not remove hidden formatting on a number | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Excel error - remove some formatting | Excel Discussion (Misc queries) | |||
| how to remove label formatting (eg label to number) | Excel Worksheet Functions | |||
Threaded Mode
