| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell
I have a spreadsheet that has social security numbers (SSN) in a column. The
numbers are missing the leading zeros and the two dashes for the SSN format (i.e. the number is XXXXXXXX instead of 0XX-XX-XXXX. If you look in the cell, the you see only 8 numbers, but when you format you of course see the SSN format...000-00-0000. I need to add the leading zero and then the two dashes (this because I am transferring the numbers to another software package). My data set is large..manual entry will take forever. Any ideas are welcome. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell
See response in excel.misc
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Allan" wrote in message ... I have a spreadsheet that has social security numbers (SSN) in a column. The numbers are missing the leading zeros and the two dashes for the SSN format (i.e. the number is XXXXXXXX instead of 0XX-XX-XXXX. If you look in the cell, the you see only 8 numbers, but when you format you of course see the SSN format...000-00-0000. I need to add the leading zero and then the two dashes (this because I am transferring the numbers to another software package). My data set is large..manual entry will take forever. Any ideas are welcome. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell contents truncated | Excel Discussion (Misc queries) | |||
| I want to add dashes in a cell which has both number and tex | Excel Discussion (Misc queries) | |||
| How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell | Excel Discussion (Misc queries) | |||
| Cell Format & Dashes | Excel Discussion (Misc queries) | |||
| Cell Character truncated. | Excel Discussion (Misc queries) | |||
Linear Mode
