how do i change the default number type which is formatted in new.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i change the default number type which is formatted in new spreadsheet
 
Create a new workbook
Change the Normal style (Format>Styles 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 File>Save 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering 'GTi' but I get 'Gti' ! 2
How do I set the default numeric format in Excel 2007 (XP)? 1
Spreadsheet changing currency format 2
Change Default Number Format 1
Defaulting to date format 4
How do I change default number format? 2
Formatting a number as a date 1
Default number format in Excel 1

Back
Top