software

I keep having to change the Decimal places from 2 to 0, check the quot;Use 1000
Separatorquot; and select for quot;Negative numbersquot; 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

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)

quot;Amyquot; gt; wrote in message
...
gt; I keep having to change the Decimal places from 2 to 0, check the quot;Use
1000
gt; Separatorquot; and select for quot;Negative numbersquot; the red with parenthesis
gt; formatting. Is there a way to set these to a default so I don't have to
keep
gt; doing it?
gt;
gt; There is an option to fix the number of places in Options, but it doesn't
gt; work in this case.
gt;
gt; Thank you!
gt; 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.

quot;Bob Phillipsquot; wrote:

gt; Do it in an empty workbook, then save that book as Book.xlt in the XLStart
gt; directory.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Amyquot; gt; wrote in message
gt; ...
gt; gt; I keep having to change the Decimal places from 2 to 0, check the quot;Use
gt; 1000
gt; gt; Separatorquot; and select for quot;Negative numbersquot; the red with parenthesis
gt; gt; formatting. Is there a way to set these to a default so I don't have to
gt; keep
gt; gt; doing it?
gt; gt;
gt; gt; There is an option to fix the number of places in Options, but it doesn't
gt; gt; work in this case.
gt; gt;
gt; gt; Thank you!
gt; gt; Amy
gt;
gt;
gt;

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 quot;-quot; is treated as a quot;Generalquot; value, rather than quot;Number.quot;

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

quot;Amyquot; wrote:

gt; Hi Bob,
gt;
gt; I tried this. It had no effect. Any new sheet I created in Excel still
gt; reverts back to the MS default settings.
gt;
gt; Any other ideas? This is Excel 2003.
gt;
gt; A.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Do it in an empty workbook, then save that book as Book.xlt in the XLStart
gt; gt; directory.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Amyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I keep having to change the Decimal places from 2 to 0, check the quot;Use
gt; gt; 1000
gt; gt; gt; Separatorquot; and select for quot;Negative numbersquot; the red with parenthesis
gt; gt; gt; formatting. Is there a way to set these to a default so I don't have to
gt; gt; keep
gt; gt; gt; doing it?
gt; gt; gt;
gt; gt; gt; There is an option to fix the number of places in Options, but it doesn't
gt; gt; gt; work in this case.
gt; gt; gt;
gt; gt; gt; Thank you!
gt; gt; gt; Amy
gt; gt;
gt; gt;
gt; gt;

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