| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Question
I think you maybe can create your own style.
"Zecarioca" wrote: That works to change the decimal places, but I also wanted to change the default category (i.e. accounting, currency, number). Any thoughts? "Dave F" wrote: Tools--Options allows you to change default settings and apply them for future instances of Excel. -- Brevity is the soul of wit. "Zecarioca" wrote: How can I change the default setting for cell formatting - even on existing spreadsheets. I wanted all numbers to be inputed as currency with 0 decimal places, but it always defaults to numbers with 2 decimal places. I know I can change the formatting after the fact, but I wanted this to be the default setting. Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forrmula Formatting question... | Excel Discussion (Misc queries) | |||
| Tough conditional formatting question | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Formatting Question | Excel Worksheet Functions | |||
| Area Chart Formatting Question | Charts and Charting in Excel | |||
Threaded Mode
