Can you set to default the # of decimal places in Format Cells?

[Amy]

I keep having to change the Decimal places from 2 to 0, check the "Use 1000
Separator" and select for "Negative numbers" the red with parenthesis
formatting. Is there a way to set these to a default so I don't have to keep
doing it?

There is an option to fix the number of places in Options, but it doesn't
work in this case.

Thank you!
Amy

 

[Bob Phillips]

Do it in an empty workbook, then save that book as Book.xlt in the XLStart
directory.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Amy]

Hi Bob,

I tried this. It had no effect. Any new sheet I created in Excel still
reverts back to the MS default settings.

Any other ideas? This is Excel 2003.

A.

 

[Amy]

To be more specific, after a second attempt, I found that while it zeros out
the decimal places, it still does not use red and parenthesis for negative
numbers. I noted under Cell Format that the cell with a negative number (
with a "-" is treated as a "General" value, rather than "Number."

I did try selecting the entire empty worksheet and then making the
selections in the Cell Format, to Number, zero decimal places, use 1000
separator and negative numbers in red with parenthesis.

Only the decimal places setting seemed to hold.

Amy

 

[Pete_UK]

I think you will need to close Excel for this to take effect.

Alternatively, you might have another Book.xlt somewhere - try
searching for it and renaming it if you find one (you can always delete
it afterwards). Then set up a blank workbook as Bob suggested and save
this as Book.xlt. Then close and re-open Excel.

Hope this helps.

Pete