Here's a similar question I posted yesterday, and the
answer. Do the same thing, but instead of setting all
cells to wrap text set them to number format with 2
decimal places.

Linda
---------------------------------

Hit CRTL + A to select all cells.

FormatAlignmentWrap Text.

To make this the default for all new workbooks and
sheets....

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 FileNewWorkbook.

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).

Gord Dibben Excel MVP

On Thu, 17 Jun 2004 06:36:20 -0700, "L Schmandt"
wrote:

How can I customize Excel so that the default for all
cells in a worksheet is always to wrap text? It drives
me
nuts to have to do this every time, when I almost never
DON'T want text to wrap.



-----Original Message-----
How can I set the default newly opened spreadsheet to be
globally set to say 2 decimal places please ? The Tools
option allows you to set decimal places to 2 but simply
takes any number you enter and multiplies by 100. ie
entering 1234 displays as 12.34. I want the default to be
the same as globally selecting the whole sheet and then
setting the number format to 2 decimal places.
Thanks.
.