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?
|
|
|