How do I insert hypens in existing column representing social sec.

H

hard head

I need to insert two hyphens in an existing column of numbers (represents
social security numbers) in Excel, i.e. xxx-xx-xxxx. Is there a formual that
will accomplish this?
 
P

Peo Sjoblom

Yes, in US excel there is a ssn format under format>cells>number>special
it looks like

000-00-0000

that assumes that your data are numbers and not text


Regards,

Peo Sjoblom
 
Top