| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change number formatting
Hi skrout
Select all cells first You can use this line in a macro Selection.NumberFormat = "000-00-0000" -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "skrout" wrote in message ... 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) | |||
| How to change number formatting | Excel Programming | |||
| How to change number formatting | Excel Programming | |||
| How to change number formatting | Excel Programming | |||
Threaded Mode
