Excel copy and paste
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 |
Excel copy and paste
Suspect it's just a case of the calc mode being inadvertently at manual
Click Tools Options Calculation tab Check "Automatic" OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "beejj" wrote: 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 |
All times are GMT +1. The time now is 06:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com