Excel copy and paste

  • Thread starter Thread starter beejj
  • Start date Start date
B

beejj

I did something dumb. When i copy and paste a formula, the correct formula
copies but the original copied number is displayed.

ie cell g4 (8) - cell g5 (4) = cell g6 is, g4-g5, displays 4.00

typical copy and paste

ie cell h4 (25) - cell h5 (4) = cell h6 is, h4-h5, BUT displays 4.00 AGAIN
!!!
help please
 
Suspect it's just a case of the calc mode being inadvertently at manual
Click Tools > Options > Calculation tab > Check "Automatic" > OK
 
Back
Top