Rounding in fixed point.
If you've got a number like 0.23, try to work out what binary number gives
that number exactly. Same for 0.77. Add the two together and subtract one,
and you hope you'll get zero, but as the original binary representations
weren't exact, the answer may not be exactly zero.
You could try =ROUND(your_formula,2)
--
David Biddulph

"Julie" wrote in message
...
okay, when i extend the decimal point out to about 27, it shows there are
some numbers. i am only adding and subtracting in all of the formulas on
this
spreadsheet. I check all of the cells and none of them have more than 2
decimals. So I am still confused.

"Julie" wrote:

I have a cell formated with 'Accounting' and if I enter a zero a line
appears. I copied that format to other cells but a few of the cells show
0.00 instead. I check the formating and it looks the same. Where do I
correct this. I want them all to show as a line.

Thank You,
Julie