how to format data with an input mask like ss# (***-**-****)

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I am trying to format text with an input mask like the one used for a SS#.
But what iI need would look like this (***-***-***-**-***). Is there a way to
add this to the "canned" format selection?
Thanks in advance for your help
 
Hi Dennis!

1. Select the cell or range of cells that you want to format.
2. On the Format menu, click Cells.
3. On the Number tab, click Special in the Category list.
4. In the Type list, Social Security Number.

Please note that these codes are available in the Type list only if the
Locale (location) is set to English (United States). Hope it works for you.
 
Back
Top