Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Workbook Defaults
I want to setup my Excel so that whenever I create or open a workbook or
sheet, the cell's will always be defaulted to currency format. How do I do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Workbook Defaults
You can do it (but you won't want to!) by:
Creating a new workbook. Change the normal style for numbers to be currency. In xl2003 menus: Format|style|select Normal|Modify and change to the number format you want. Save it as a template named book.xlt (.xltx or .xltm in xl2007???) and store it in your XLStart folder. xl2003 and below will use that template workbook when you create a new workbook by clicking on the new icon on the standard toolbar. ===== The reason you won't want to use this is the way it treats any numeric entry--even dates and times. WildWill wrote: I want to setup my Excel so that whenever I create or open a workbook or sheet, the cell's will always be defaulted to currency format. How do I do that? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Excel defaults | Excel Discussion (Misc queries) | |||
Is there a way to change my defaults to print the entire workbook? | Excel Discussion (Misc queries) | |||
Subject line in email defaults to workbook file name. | Excel Discussion (Misc queries) | |||
Subject line in email defaults to workbook file name. | Excel Discussion (Misc queries) | |||
Workbook Defaults to Printing 33 Copies | Excel Discussion (Misc queries) |