View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Yes, in US excel there is a ssn format under formatcellsnumberspecial
it looks like

000-00-0000

that assumes that your data are numbers and not text


Regards,

Peo Sjoblom

"hard head" wrote:

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?