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?

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?

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?

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

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

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

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?

Gord,

You are the man!! Perfect. Thank you so much for the help!!!



"Gord Dibben" wrote:

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?

After you have the result then do Copypaste specialvalues


"Brian Denny" wrote:

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?

Teethless,

Funny screen name. Must be popular with the local guys. Anyway, thanks for
the help. You were right on as well. I appreciate your effort.



"Teethless mama" wrote:

After you have the result then do Copypaste specialvalues


"Brian Denny" wrote:

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?