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

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

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

Try Format Cells - NUmber - Custom

###-###-###-##-##

--
HTH,
Barb Reinhardt



"Dennis" wrote:

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

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

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.