Excel Problem: Cell wont display correct value when i copy it over!!

[Akaz1976]

Consider following problem!

A1 = 3 (that is, cell A1 contains value "3&quot
A2 = 2
B1 = 4
B2 = 2

Now i put following formulas in the following cells:

A3 = A1/A2 this displays value "1.50"

When i copy A3 to B3, B3 shows "B1/B2" as the copied over formula (which is fine) but value that is displayed is "1.50" where as it should be "2.00" ( = 4/2 ).

Only when i hit save does the value displayed in B3 change to "2.00".

Anyone know why that would happen? It happened before and it was very annoying but it fixed it self, now its happenning again

Help

Thanx

Akaz

 

[coder1]

Sounds like a possible rounding issue

 

[Akaz1976]

its showing up to 2 dcimal places so i dont see how it would be a rounding issue. also why hitting "save" cause the displayed value to change? and i tried it with widely different #s and still it wont change, so definately not a rounding issue!

 

[BadThad]

Hummm...check this: Go to tools, options, calculation. Make sure "automatic" is selected. I tried your test and it works fine on Excel 2000. Note: Normally I cross-hair drag formulas to the desired cell when they are adjacent, faster than a copy/paste.

Good Luck!

 

[Akaz1976]

work

Thanx

Akaz