Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Want to open worksheet in preformatted style
I a CPA and almost all my worksheets need to be formatted in a number style
with 2 decimal places and comma separator. How do I format my worksheet so that ever one I open up is already formateed to numbers, 2 decimal places and comma separator? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Want to open worksheet in preformatted style
Open a new workbook. Customize as you wish.
FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART This will be the default workbook for FileNew or the Toolbar button FileNew or CTRL + n WARNING................Do not use FileNew...Blank Workbook or you will get the Excel default workbook. NOTE: Existing workbooks are not affected by these settings. You can also open a new workbook and delete all but one sheet. Customize as you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes the default InsertSheet. More can be found on this in Help under "templates"(no quotes). NOTE # 2....................you may find it handy to use "Fixed Decimals" so's any number you enter will divide by 100 Enter 12345 and get 123.45 actual. Just be careful................this is a global setting and would affect all sheets and books. Gord Dibben MS Excel MVP On Mon, 15 Sep 2008 09:06:11 -0700, Darrell Hillis, CPA <Darrell Hillis, wrote: I a CPA and almost all my worksheets need to be formatted in a number style with 2 decimal places and comma separator. How do I format my worksheet so that ever one I open up is already formateed to numbers, 2 decimal places and comma separator? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
QUESTION REGARDING LOCKING SPREADSHEETS AND PREFORMATTED CELLS | Excel Discussion (Misc queries) | |||
font style of worksheet functions | Excel Worksheet Functions | |||
changing font style in a complex worksheet function | Excel Worksheet Functions | |||
changing type style and colour within a worksheet function | Excel Worksheet Functions |