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" wrote in message
...
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