displaying negative values

[cfuller]

how do I hide the display of negative numbers?

[Marcelo]

=if(A1<0,"",A1)

HTH
Regards from Brazil
Marcelo

"cfuller" escreveu:

> how do I hide the display of negative numbers?

[Ken Hudson]

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

--
Ken Hudson


"Marcelo" wrote:

> =if(A1<0,"",A1)
>
> HTH
> Regards from Brazil
> Marcelo
>
> "cfuller" escreveu:
>
> > how do I hide the display of negative numbers?

[Ragdyer]

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cfuller" <[email protected]> wrote in message
news:[email protected]...
> how do I hide the display of negative numbers?