If only I could attach this darn spreadsheet. It looks awful, and I can't
get the dollar signs to line up properly on the left hand side. This should
be a default. Speaking of which: Excel 2000, third pull-down under formating
cells, accounting, has the option of using the following to properly use
parentheses with negative numbers and dollar signs:

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

However, in their infinite wisdom, someone deleted this default from Excel
2005. There is likely a way of saving it in custome settings, but I don't
know how and have to do it in each individual sheet. What happened?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Excel 2005? Don't you mean Excel 2003?

--
Please post all replies to the newsgroup for the benefit of others.
Requests for assistance by email will NOT be acknowledged!



"DGWeeks" wrote in message
...
If only I could attach this darn spreadsheet. It looks awful, and I can't
get the dollar signs to line up properly on the left hand side. This should
be a default. Speaking of which: Excel 2000, third pull-down under formating
cells, accounting, has the option of using the following to properly use
parentheses with negative numbers and dollar signs:

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

However, in their infinite wisdom, someone deleted this default from Excel
2005. There is likely a way of saving it in custome settings, but I don't
know how and have to do it in each individual sheet. What happened?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...lic.excel.misc