Put % in ( )

  • Thread starter Thread starter gatarossi
  • Start date Start date
G

gatarossi

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é.
 
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é.
 
Back
Top