Negative
in [General]
|
From: Jon on 30 Apr 2010 08:42 I have a summary sheet for a month's worth of data and I need the negative's that appear to come out as zero's -- Jon
From: Pete_UK on 30 Apr 2010 08:45 Try this amendment to your existing formulae in those cells: =MAX(0,existing_formula) Hope this helps. Pete On Apr 30, 1:42 pm, Jon <J...(a)discussions.microsoft.com> wrote: > I have a summary sheet for a month's worth of data and I need the negative's > that appear to come out as zero's > -- > Jon
From: Jacob Skaria on 30 Apr 2010 08:49 Custom format the cells to the below (from menu Format>Cell>Custom>Type) General;"0";0 -- Jacob (MVP - Excel) "Jon" wrote: > I have a summary sheet for a month's worth of data and I need the negative's > that appear to come out as zero's > -- > Jon
From: BSc Chem Eng Rick on 30 Apr 2010 08:51 Hi Jon, Use this formula: =IF("Cell Reference"<0,0,"Cell Reference") -- If this helps, please click "Yes" <><><><><><><><><><><> "Jon" wrote: > I have a summary sheet for a month's worth of data and I need the negative's > that appear to come out as zero's > -- > Jon
From: Bernard Liengme on 30 Apr 2010 08:53 Hopefully your numbers are generated by formulas. Then you can modify them to read =IF(your_formula<0,0,your_formula) or =IF(your_forumula,your_formula,0) or your_formula*(your_formula>0) Or, if it is only for appearance and no further calculations are involved, use a custom format like #,"0","0" best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Jon" <Jon(a)discussions.microsoft.com> wrote in message news:93F9DED9-A9E4-4A51-A632-DC3C6ECFEEEE(a)microsoft.com... > I have a summary sheet for a month's worth of data and I need the > negative's > that appear to come out as zero's > -- > Jon
|
Next
|
Last
Pages: 1 2 3 Prev: automatically change time in sheet 2, 3, and 4. Next: Auto Sizing Charts / Tables |