Sending a raw number to a cell from a calculated cell
 

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?

Sending a raw number to a cell from a calculated cell
 

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?

Sending a raw number to a cell from a calculated cell
 

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?

Sending a raw number to a cell from a calculated cell
 

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

Sending a raw number to a cell from a calculated cell
 

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

Sending a raw number to a cell from a calculated cell
 

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

Sending a raw number to a cell from a calculated cell
 

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?

Sending a raw number to a cell from a calculated cell
 

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?

Sending a raw number to a cell from a calculated cell
 

Niek,

Sorry for the delay in response, but I took my kids to a bday party and just
returned. No this did not work. Still has the formula in the B1 cell. I
will try Gord's suggestion and see if that works out. And Gord it correct,
this is exactly what I am trying to accomplish.



"Niek Otten" wrote:

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

Sending a raw number to a cell from a calculated cell
 

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?

Sending a raw number to a cell from a calculated cell
 

Niek,

I really appreciate your efforts. Many times I try to help someone with the
business I am very good at and don't make the trip, but I always appreciate
someone thanking me for the time I spent with the best of intentions. Your
intentions were pure and thank you so much for your time!

"Niek Otten" wrote:

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

Sending a raw number to a cell from a calculated cell
 

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?