Select B1
FormatCellsNumber tabGeneralOK

Press F2, then press ENTER

It should be OK now. Is it?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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