 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008how 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 Try Format Cells -> NUmber -> Custom ###-###-###-##-##  SignatureHTH, Barb Reinhardt > 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.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.