Change default number format

  • Thread starter Thread starter mbrucker
  • Start date Start date
You could create a template workbook (*.xlt) and format all the cells with the
numberformat you want.

Then use that whenever you want to use that special format.

If you want to use that number format for all new workbooks, name the template
workbook book.xlt and store it in your XLStart folder.

If you save another copy as sheet.xlt, then any new sheet added to an existing
workbook will inherit that number format.
 
Right click the cell. > format cells

On the "Number" Tab change the format of the number to what you desire

Or search help on "create a custom number format "
 

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

Defaulting to date format 4
Formatting a number as a date 1
Number formats default to dates 1
Default number format in Excel 1
How do I set the default numeric format in Excel 2007 (XP)? 1
Spreadsheet changing currency format 2
Change Default Number Format 1
How to change the default format for date? 3

Back
Top