Enter Numbers as Text in Social Security Number Format

[Lamar]

This is my issue. I need for my clients to be able to
enter Numbers as Text in the Social Security Number
Format. I know a cell can be formatted as SSN but then
the data type is Number.

But I need the data type as Text but keep the formatting.
Because I take the SSN then use in a query and but the
data type in SQL Server is Text.

I know convert column to text but I was trying to save a
step. Any ideas.

 

[Frank Kabel]

Hi
if you have stored your social security number in column A (as number)
use a helper column (lets say B):
- enter the following in B1:
=TEXT(A1,"000-00-0000")
(apply the format to your needs)
- copy down for all rows
- after this select column B, copy it and insert it again as Values
('Edit - Paste Special')