Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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:- |
#2
![]() |
|||
|
|||
![]()
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:- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
#VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Paste Special Question | Excel Discussion (Misc queries) |