Thread
:
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell
View Single Post
#
8
Posted to microsoft.public.excel.misc
Allan
external usenet poster
Posts: 57
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a c
Marcelo...your solution is excellent!...Thanks a bunch...I would love to keep
in touch.
"Marcelo" wrote:
Hi Allan,
try ="0"&left(a2,2)&"-"&mid(a2,3,2)&"-"&right(a2,4)
hth
regards from Brazil
Marcelo
"Allan" escreveu:
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 With Quote
Allan
View Public Profile
Find all posts by Allan