RE: how to format data with an input mask like ss# (***-**-****)
- From: Lt. Bonifacius <LtBonifacius@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 28 Mar 2008 15:31:00 -0700
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.
.
- References:
- Prev by Date: RE: How can I print only select sheets in my workbook?
- Next by Date: Re: Reduce Size of Blank Rows (again)
- Previous by thread: how to format data with an input mask like ss# (***-**-****)
- Next by thread: Re: need help writing a formula in excel
- Index(es):
