Formatting SSN as Text

[Rob]

I want the data enter to show in SSN format but need the
data type as text.

Is there a way to do this? I can not convert to text
(Data Text to Columns) because if the SSN starts with a
zero then the zero will be dropped off.

Thanks for any help.

 

[Ron Rosenfeld]

I want the data enter to show in SSN format but need the
data type as text.

Is there a way to do this? I can not convert to text
(Data Text to Columns) because if the SSN starts with a
zero then the zero will be dropped off.

Thanks for any help.

If you must have it as text:

=TEXT(SSN,"000-00-0000")


--ron