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

problem with formulas (2) 7
Tighter formula than this? 5
How do I get an IS and IF statement to work together in excel? 3
Need Min Value from Row and Heading Value that Corresponds to it. 1
Calculate Elapsed Date and Time 3
Sumif on columns with logical answers 1
Help with functions and percentages 1
Looking Up Two Values in an Array 4

Top