Sending a raw number to a cell from a calculated cell

B

Brian Denny

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

Niek Otten

Not sure what you're after, but do check HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

Brian Denny

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!
 
N

Niek Otten

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


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

Brian Denny

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
 
N

Niek Otten

Select B1
Format>Cells>Number tab>General>OK

Press F2, then press ENTER

It should be OK now. Is it?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

Gord Dibben

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 copy>paste special>value>OK>Esc


Gord Dibben MS Excel MVP

On Sat, 18 Nov 2006 11:41:02 -0800, Brian Denny <Brian
 
B

Brian Denny

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.
 
B

Brian Denny

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!
 
B

Brian Denny

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.
 
Top