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

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