View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
beejj beejj is offline
external usenet poster
 
Posts: 1
Default 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