format social security number as XXX-XX-1234

  • Thread starter Thread starter Svetlana
  • Start date Start date
S

Svetlana

Does someone know how to format a social security number
as XXX-XX-1234? I know how to do this using concatenate
function, but would like to find out if it is possible
using the formatting programming. I tried:
_("XXX-XX-"0_) and _("XXX-XX-"#_), but that i still get
the whole number after the X's.
Thanks!
Svetlana
 
This will work:

(assuming there's an SSN in cell A1):

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

Hope this helps!
 
Why can you not use a copy and past special when using this function. I have several hundred rows that need to be formatted, and it does not allow me to copy the formula to multiple cells.
 
When you say "formula" are you talking about the format itself?
If you select the rows then "Format->Cells->Special" and click the
Social Security Number format it will apply that format to all the
selected cells.

--
Regards;
Rob
------------------------------------------------------------------------
Arthur said:
Why can you not use a copy and past special when using this function.
Click to expand...
I have several hundred rows that need to be formatted, and it does not
allow me to copy the formula to multiple cells.
 
Back
Top