19 Replies Latest reply: Jan 14, 2013 4:44 AM by Dave Riley RSS

    Money rounding cents to .00

    Hein Schultz

      Hi All

       

      I cannot understand why my cents are being rounded to .00

       

      When i select Number, 2 Decimals a figure will show (for instance) 123.50. But as soon as i make it Money, it shows as 124.00

       

      This is the formula in the chart is this:

      R # ##0.00;R-# ##0.00

       

      Can anyone please advise what i am doing wrong?