Niek,

I have =(A1/.5) in the B1 cell, not 200 when I click on the cell. 200 is
visable in the cell, but the formula remains behind the scenes. I need C1 to
contain the answer from the formula as just the number 200. Just like if you
clicked in C1 and entered 200. No formula behind the cell, just a pure and
simple number. Is there a way to send the results of a cell formula to
another cell? Maybe I can do it that way.

I tried erasing the formula in B1 and entering (F2, ENTER) as suggested, and
all I get in the cell is (F2, ENTER). Nothing more. I know I am quite a
novist at this, but I am trying to import the data to a pricing sheet that
must see the numbers as just numbers, no formulas.

Thanks again

"Niek Otten" wrote:

In C1:

=B1

What do you see in your worksheet in B1:
200
or
=(A1/.5)
?
If you see =(A1/.5); format as General and re-enter the formula (F2, ENTER)

BTW, what do you mean with a "simple" number? Please give an example of what you expect to see in C1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Brian Denny" <Brian wrote in message ...
|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?
|
|
|