| 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 Formatting Pls help -- Dr. Sachin Wagh MBBS, DHA, DPH |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Special format for negative figures
FormatCellsNumberCustom
In the Type box, enter 0%;(-0%) -- Kind regards, Niek Otten "Dr. Sachin Wagh" wrote in message ... 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 Formatting Pls help -- Dr. Sachin Wagh MBBS, DHA, DPH |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Special format for negative figures
Thanx Niek
-- Dr. Sachin Wagh MBBS, DHA, DPH "Niek Otten" wrote: FormatCellsNumberCustom In the Type box, enter 0%;(-0%) -- Kind regards, Niek Otten "Dr. Sachin Wagh" wrote in message ... 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 Formatting 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) | |||
Linear Mode
