displaying negative values

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,
That will work if cell A1 has a formula in it.
If negative numbers are just typed in, you can use conditional formatting.
Highlight the range of cells you want to format.
Go to Format > Conditional Formatting...
Enter cell value is less than 0.
Click the Format... button and select Color: and then click the white icon.
HTH
 
Select the cells you wish to format in this way, then:
<Format> <Cells> <Number> tab,
Click on "Custom" in the left (Category) window,
In the "Type" box, on the right, enter:
General;

This custom format will hide the display of negative numbers, either keyed
in, or returned from formulas.
 
Back
Top