Format Social Security Number as Text

  • Thread starter Thread starter Robert
  • Start date Start date
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?
 
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
 
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.
 
Back
Top