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?