| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format social security number as XXX-XX-1234
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a social security number to have no dashes? | Excel Discussion (Misc queries) | |||
| last four digits of a social security number | Excel Worksheet Functions | |||
| format social security number | Excel Worksheet Functions | |||
| Social Security Number | Excel Discussion (Misc queries) | |||
| Social Security Number format | Excel Worksheet Functions | |||
Threaded Mode
