Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i change the default number type which is formatted in new.
how do i change the default number type which is formatted in new spreadsheet
|
#2
|
|||
|
|||
Create a new workbook
Change the Normal style (FormatStyles from the menu) to reflect your preferred number format. You can also change font style and size if your prefer. Save the workbook as a template - choosing FileSave As and select Template under the 'Save As Type' dropdown at the bottom, saving it with the name BOOK.XLT in the directory C:\Program Files\Microsoft Office\Office10\XLStart\ If you have an older or newer version, you may not see the Office10 subdirectory, so adjust as appropriate. Once you've done this (you may have to close & restart Excel), every new standard workbook will be based on the one you just svaed. "Angus" wrote: how do i change the default number type which is formatted in new spreadsheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change default measurements from cm to inches | Setting up and Configuration of Excel | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Change the default chart colours | Charts and Charting in Excel | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel |