anything in Excel...

It's Excel-o-lozy...

TrickPro - %age formatting

-12,345 can be easily formatted as (12,345).
But how to format -10% as (10)% as is best suited format for financial reporting.

Easy...

Select the cells;
go to "Format Cells";
under "Number" tab select "Custom";
in the right side under "Type:" write as follows:
0%; (0)%

Voila, done, easy no....

0 comments: