| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with social security numbers
I am trying to remove the hyphen from between social security numbers;I'm
able to do so using the 'text to column' function, but I am having a problem with those numbers that are preceded by 0's eg : 001-23-0077 the function is dropping the zero's and returning 1-23-77.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove dashs from social security numbers | Excel Discussion (Misc queries) | |||
| social security numbers in Excel | Excel Discussion (Misc queries) | |||
| Unformating social security numbers | Excel Discussion (Misc queries) | |||
| Social Security numbers | New Users to Excel | |||
| social security numbers | Excel Worksheet Functions | |||
Threaded Mode
