| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Excel copy and paste | Excel Worksheet Functions | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| copy and paste into excel | Excel Discussion (Misc queries) | |||
| copy and paste from excel to ppt with VBA | Excel Discussion (Misc queries) | |||
Linear Mode
