| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format Cells - Custom
I am trying to convert data I receive to a specific format. I receive social
security numbers as text, occasionally the file comes over without the dashes between the numbers. I tried converting the text to number and then did a custom format to include the dashes. This works however if the social has a leading zero (0) did loses it when converted. Any suggestions? Thanks -- Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom format for cells | Excel Discussion (Misc queries) | |||
| FORMAT Cells - Custom | Excel Discussion (Misc queries) | |||
| Custom format for cells | Excel Discussion (Misc queries) | |||
| custom cells format | Excel Discussion (Misc queries) | |||
| Custom Format Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
