John's not raining on your idea. He's giving you the facts.

It's no use telling us what you want to see in Excel. We all have our pet
enhancements we'd like to see. But there's only one entity which can
implement the enhancements -- Microsoft. This is a group of users. If you
want to submit an enhancement request, send it directly to Microsoft.

Regards,
Fred.

"Tschurin" wrote in message
...
John

I'm not sure why you are raining on this idea. You say it is "easy enough
to
do;" if you deal with a dozen charts a day with rows of negative
percentages
then "easy enough to do" becomes a time wasting chore. Besides:
1) This suggestion is consistent with what excel already does with other
numbers
2) improves the legibility of percentages and thus makes it less likely
that
someone might make a mistake reading percentage numbers
3) It's not like it would be terribly complicated.
You say that custom numbers provide "good flexibility." For negative
numbers
you don't need a lot of flexibility; red is the accepted color for
negative
numbers.
You say the list is for more "basic uses." How much more basic can a
negative percent be; for the sake of discussion we can assume a percentage
change has just as much a chance of being negative, as of being positive.
Some of the suggestions you say you would like may in fact be good. Push
those ideas, instead of raining on others peoples' ideas.

Geoff



"John C" wrote:

Custom number format is easy enough to do.... Why can't I have an
automatic
choice for fractions with up to 4 digits in the denominator? up to 5
digits?
Why not a date format of mm/dd/yyyy as a default choice instead of doing
customs....The custom provides good flexibility, and the lists are the
more
'basic' uses... Just my 2 cents.
--
** John C **

"Tschurin" wrote:

I understand from looking at past threads that there is a way to
conditionally format a negative percent so that it is red.

But why isn't that a choice automatically provided by Excel?

When you format a cell with a number in it, you are given a choice to
format
a negative number in black or red, with or without a parenthesis around
the
number.

Why shouldn't you have the option of formatting a negative percentage
in
red, with or without parentheses. Red with parentheses is much easier
to read
than the thin negative sign to the left in black. At least one should
have
the option.

Geoff

----------------
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...et.f unctions