Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I convert a formula calculated number to a current value ?
Trying to use the formula calculated number as a current value-
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I convert a formula calculated number to a current value ?
OK. Now what is the problem?
-- Kind regards, Niek Otten "Chandler" wrote in message ... Trying to use the formula calculated number as a current value- |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I convert a formula calculated number to a current value ?
Another guess, drawing by the subject line ..
To say, freeze the values / kill the formulas in a col, select the col, then do an "in-place": Copy Paste special Check "Values" OK -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Chandler" wrote in message ... Trying to use the formula calculated number as a current value- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated fields in pivot tables | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |