Enter Numbers as Text in Social Security Number Format

  • Thread starter Thread starter Lamar
  • Start date Start date
L

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.
 
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')
 
Back
Top