Format Social Security Number as Text

R

Robert

I want to be able to enter numbers in a cell formatted as
a Social Security Number but I want the data type to be
text. Is this even possible?
 
F

Frank Kabel

Hi Robert
if you want the automatic formating applied you have to format the cell
as number. But you may enter the following formula in the adjacent
column to get a text value
=TEXT(A1,"formatcode")
replace formatcode with the format for social security numbers.
Probably something like 00-0000-00
 
P

Peo Sjoblom

Only by using an VBA or a help column with formulas..
Since you posted in function here is a function

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

copy down and paste special as values will make the text constants.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Format Cells - Custom 1
Calculating Social Security 3
format social security number 2
Enter Numbers as Text in Social Security Number Format 1
How do I sum here using criteria there? 10
Cell Format 3
Custom number formatting 9

Top