![]() |
Number formatting
I have formatted a cell to show negative numbers with a preceding minus sign
and black font. However when the value of the cell is negative the number is still being displayed in red. Is there a format setting that is overriding the number format I have specified? I am using Excel 2003 SP2. -- R Ormerod |
Number formatting
Conditional formatting, if set, does it!
Regards, Stefi €˛R Ormerod€¯ ezt Ć*rta: I have formatted a cell to show negative numbers with a preceding minus sign and black font. However when the value of the cell is negative the number is still being displayed in red. Is there a format setting that is overriding the number format I have specified? I am using Excel 2003 SP2. -- R Ormerod |
All times are GMT +1. The time now is 07:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com