Brian

Are you asking for C1 to contain 200 without having a formula in C1 to pull from
B1?

Cannot be done without using VBA

Or in C1 enter =B1 then copypaste specialvalueOKEsc


Gord Dibben MS Excel MVP

On Sat, 18 Nov 2006 11:41:02 -0800, Brian Denny <Brian
wrote:

I was not able to get that to work for me. Maybe this is a better
explaination: Cell A1=100, B1=(A1/.5), I need C1 to = the result from B1 as
just a simple number.

Thank you for your help!


"Niek Otten" wrote:

Not sure what you're after, but do check HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Brian Denny" <Brian wrote in message ...
| Does anyone know how to send the results of a calculated cell to another cell
| as a raw number. Example: Cell A1=100, cell A2 contains this formula:
| =(A1/.5). A2 will thus contain the results of the formula which is equal to
| 200. I need that cell, or any cell to contain the answer as a raw number,
| not the calculated result. If you click on A2 as it displays 200, it shows
| the cell contents as =(A2/.5) not 200 as it need it to.
|
| Can anyone help?