| 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 | |||
Linear Mode
