Excel copy and paste

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
 
M

Max

Suspect it's just a case of the calc mode being inadvertently at manual
Click Tools > Options > Calculation tab > Check "Automatic" > OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Need Min Value from Row and Heading Value that Corresponds to it. 1
problem with formulas (2) 7
Tighter formula than this? 5
how to copy paste the figures in adjoining cells? 0
2007 conditional formatting not playing ball 5
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Sumif on columns with logical answers 1

Top