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.