Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Special format for negative figures
How do I get parenthesis i.e. () for negative %
Ex: (-5%) as we get for numbers Though managed to get it red coloured thru Conditional Formating Pls Help -- Dr. Sachin Wagh MBBS, DHA, DPH |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Special format for negative figures
Highlight the cells you want to format this way
Right click on the cells and select Format Cells On the number Tab, choose Custom In the "Type" box enter: 0.00%_);[Red](0.00%) "Dr. Sachin Wagh" wrote: How do I get parenthesis i.e. () for negative % Ex: (-5%) as we get for numbers Though managed to get it red coloured thru Conditional Formating Pls Help -- Dr. Sachin Wagh MBBS, DHA, DPH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) |