Try this Custom Number Format:
Select the cell(s) to be impacted
From the Excel Main Menu:
<format><cells><number tab>
Category: Custom
Type: (0%);(-0%);(0%)
Click [OK]
Those settings will display:
10% as (10%)
-10% as (-10%)
0% as (0%)
Is that something you can work with?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
Dear all,
Is it possible to format a cell to stay like it: ( -10% )?
With this format (0%), the excel shows this - (10%)
Thanks a lot!!!
André.
gatarossi@ig.com.br - 08 Feb 2008 20:37 GMT
Dear Ron, Thanks!!!!
Now it is ok!!!!
André.