![]() |
Paste a function as a fixed number
I need to move a big number of cells that have been calculated by using a
simple function (SUM) to anther spreadsheet. In the new spreadsheet I DON'T whant the function but only the actiul result of the sum as a fixed number. Is there an easier way to do this than to retype all the numbers again?? There are 700 so I really hope for your help:- |
Hi
copy the numbers click where you want them pasted choose edit / paste special - values the actual numbers should be pasted notthe formulas Cheers JulieD "Martini25" wrote in message ... I need to move a big number of cells that have been calculated by using a simple function (SUM) to anther spreadsheet. In the new spreadsheet I DON'T whant the function but only the actiul result of the sum as a fixed number. Is there an easier way to do this than to retype all the numbers again?? There are 700 so I really hope for your help:- |
All times are GMT +1. The time now is 07:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com