Re: Negative value and zero

From: **{Steven}** (none_at_myisp.com)
Date: 02/22/04 

Date: Sun, 22 Feb 2004 10:41:33 -0500

Never mind, understand now. I have that working. Thank you.

Steven

"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:eWziQHV%23DHA.3068@tk2msftngp13.phx.gbl...
> Fornat>Cells>Custom. In the Type box, enter #,##0;"0" or some other
format,
> as long as the part after the semicolon is a zero between quotes
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "**{Steven}**" <none@myisp.com> wrote in message
> news:%234sawDV%23DHA.2988@TK2MSFTNGP10.phx.gbl...
> > If I have a negative value and I want other equations to use that
negative
> > value but I want to cell to show a 0 whenever there is a negative, how
do
> I
> > formulate that?
> >
> > Thanks In Advance
> >
> > Steven Connor
> >
> >
>
>

Relevant Pages

  • Re: Negative value and zero
    ... In the Type box, enter #,##0;"0" or some other format, ... as long as the part after the semicolon is a zero between quotes ...
    (microsoft.public.excel)
  • Prevent Blank Records being written. Need Help.
    ... Secondary record format is as follows: ... character text field, ... no input mask requirement ... allow zero length = yes. ...
    (microsoft.public.access.forms)
  • RE: Prevent Blank Records being written. Need Help.
    ... Secondary record format is as follows: ... > no input mask requirement ... > 30 character text field, ... > allow zero length = yes. ...
    (microsoft.public.access.forms)
  • Re: zero values in bar chart
    ... If column or bar, what did you want - how do you want to plot ... If zero always means zero, then you should definitely trust your ... Create a second column data series, with the values of N or 0 as ... above, then format the series with the pale fill, or no fill. ...
    (microsoft.public.excel.charting)
  • RE: Formatting a Spreadsheet
    ... There's a checkbox under Tools, Options, on the View tab, by which you ... can control IN GENERAL the display of zero values. ... in my experience it won't be long before you need some cells to ... Select the cellwhose display format you want to change. ...
    (microsoft.public.excel.misc)