Thank you but i don't know where the odd numbers are comming from.

"Bob Umlas, Excel MVP" wrote:

It's a precision thing. Use a formula such as =ROUND(.....,5) around your
current values. Excel doesn't see them as 0, but as teeny numbers, as you
discovered.


"Julie" wrote:

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