Default formatting

[Guest]

How can I change the default setting for cell formatting - even on existing
spreadsheets. I wanted all numbers to be inputed as currency with 0 decimal
places, but it always defaults to numbers with 2 decimal places. I know I
can change the formatting after the fact, but I wanted this to be the default
setting.

Thanks for any help.

 

[Gord Dibben]

Existing workbooks will have to be re-formatted on an individual basis.

New workbooks can have the default changed.

Open a new workbook. Customize your as you wish. Note, to have all sheets
formatted to not show zeros, select one sheet tab and "Select all Sheets" to do
all sheets at once.

File>Save 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 File>New or the Toolbar button File>New

Do not use File>New...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 Insert>Sheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

How can I change the default setting for cell formatting - even on existing
spreadsheets. I wanted all numbers to be inputed as currency with 0 decimal
places, but it always defaults to numbers with 2 decimal places. I know I
can change the formatting after the fact, but I wanted this to be the default
setting.

Thanks for any help.

Gord Dibben MS Excel MVP

 

[Guest]

If I save a sheet in the XL startup folder, won't I get the problem that I
had inquired about in another post (see copy of the posting below?)

Question
After I upgraded excel to xp edition, every time I open an existing excel
file, it also creates a new worksheet (book1.xls) along with the existing
one. Is there a way to keep that from happening?
thanks,

Was this post helpful to you?


Reply | Print post TopTop





Dave Peterson 8/23/2006 12:25 PM PST
Answer
If it's really named book1.xls, then look for a file named book1.xls in
your
XLStart folder.

Either delete it or move it.

 

[Gord Dibben]

You will not run into that problem because you will save the BOOK and SHEET as
Templates(*.xlt) from the Save As>File Type.

*.XLT files do not open until you ask for them by clicking on the New File Icon
or Insert>Worksheet.

The other files like *.xls and *.xla and *.doc and any other files in XLSTART
will try to open and cause you grief.


Gord

 

[Guest]

Thanks, you were very informative.

You will not run into that problem because you will save the BOOK and SHEET as
Templates(*.xlt) from the Save As>File Type.

*.XLT files do not open until you ask for them by clicking on the New File Icon
or Insert>Worksheet.

The other files like *.xls and *.xla and *.doc and any other files in XLSTART
will try to open and cause you grief.


Gord