Select the cell (or range of cells)
format|cells|Number tab
select Custom and type in your favorite custom format in that little box to the
right.

dcoffman32 wrote:

Thanks Dave. How do I create a custom format?

"Dave Peterson" wrote:

How about a custom format of:

_(0%_);(0%);_(0%_);@

The _( and _) just reserve room for the ( and ). Then the numbers line up
nicely.

positive;negative;0;text
is the order of that formatting string.

dcoffman32 wrote:

When a formula returns a negative percentage, the result is formatted as
"-49%". Is there any format in Excel 2002 that allows for it to be formatted
"(49%)"?

--

Dave Peterson


--

Dave Peterson