| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change number formatting
Hi
Select your column and goto 'Format - Cells' and enter the following custom format: "000-00-0000" HTH Frank skrout wrote: I have a spreadsheet that for Social Security #'s format requested was for 000000000; now I have been asked to change to reflect the formatting of 000-00-0000. Is there a formula that I can use that change the formatting without having to retype over 1000 SS#'s. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change number formatting? | Excel Discussion (Misc queries) | |||
| How do I change auto formatting to allow a 0 as the first number | Excel Discussion (Misc queries) | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
| How to change number formatting | Excel Programming | |||
Threaded Mode
