I have a column that contains Social Security numbers. I would like this
column to display the numbers as 'xxx-xx-1234'. I can't seem to be able to
figure out how to do this. Cell formatting doesn't tell really say about a
'replacement' character.

Select the column
Click Format Cells Special Social Security Number
Click OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Greg Hill" <Greg wrote in message
...
I have a column that contains Social Security numbers. I would like this
column to display the numbers as 'xxx-xx-1234'. I can't seem to be able
to
figure out how to do this. Cell formatting doesn't tell really say about
a
'replacement' character.

Try using a formula in the adjacent column and then hiding the original
column. Assuming the SSN are in col. A:

="XXX-XX-"&RIGHT(A1,4)

HTH
Jason
Atlanta, GA

"Greg Hill" wrote:

I have a column that contains Social Security numbers. I would like this
column to display the numbers as 'xxx-xx-1234'. I can't seem to be able to
figure out how to do this. Cell formatting doesn't tell really say about a
'replacement' character.