ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number formatting (https://www.excelbanter.com/excel-discussion-misc-queries/196864-number-formatting.html)

R Ormerod

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

Stefi

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