How do I convert a formula calculated number to a current value ?

Chandler · January 1st, 2006, 07:06 PM posted to microsoft.public.excel.newusers

Trying to use the formula calculated number as a current value-

Niek Otten · January 1st, 2006, 07:28 PM posted to microsoft.public.excel.newusers

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-

Max · January 2nd, 2006, 12:44 AM posted to microsoft.public.excel.newusers

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-

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula checking multiple worksheets	sonic-the-mouse	Worksheet Functions	11	June 6th, 2005 06:37 PM
Need Help In Printing Current Record in Specific Report	RNUSZ@OKDPS	Setting Up & Running Reports	1	May 16th, 2005 09:06 PM
How to convert a text field to a number filed in a formula?	BBIT	Database Design	1	May 9th, 2005 10:12 PM
In Exel, how to convert formula cell into number cell?	271Spitfire	General Discussion	1	August 27th, 2004 07:11 PM
Excel formula to convert number to words	Frank Kabel	Worksheet Functions	3	March 11th, 2004 01:11 PM