Formulas to Values

[DJaded]

What might cause, and how can I stop formulas from being automatically
converted to values? When I enter a formula into a cell, it is immediately
stored as the RESULT, not the actual formula. This is not consistent, even
with formulas that are "COPY-DOWN" [<Ctrl-D>] in the same column. Some
formulas remain and some convert to their resulting value.

 

[Bernard Liengme]

Do you mean that when you look in the Formula Bar you see a value, not a
formula?
Cell, of course, normally show values
If you tell us more we might be able to help
Any change you have a lurking macro?
best wishes

 

[franciz]

would you elaborate on what you want to achieve?
do you want to show the result of the formula or you want to show
the formula itself?

 

[DJaded]

The formula bar shows the result. Subsequently, changing the values in the
cells referenced by the original formula will not change the value in the
cell.

Do you mean that when you look in the Formula Bar you see a value, not a
formula?
Cell, of course, normally show values
If you tell us more we might be able to help
Any change you have a lurking macro?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

What might cause, and how can I stop formulas from being automatically
converted to values? When I enter a formula into a cell, it is immediately
stored as the RESULT, not the actual formula. This is not consistent, even
with formulas that are "COPY-DOWN" [<Ctrl-D>] in the same column. Some
formulas remain and some convert to their resulting value.

 

[DJaded]

I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into
cell DO61. When I hit <enter>, the cell value shows "0.700" and the formula
bar shows "0.7". I'm trying to determine a Won/Lost percentage that will
re-calculate when I change the Won/Lost record. Obviously, if the formula is
replaced by the current value, changing the record will not change the
percentage.

would you elaborate on what you want to achieve?
do you want to show the result of the formula or you want to show
the formula itself?

What might cause, and how can I stop formulas from being automatically
converted to values? When I enter a formula into a cell, it is immediately
stored as the RESULT, not the actual formula. This is not consistent, even
with formulas that are "COPY-DOWN" [<Ctrl-D>] in the same column. Some
formulas remain and some convert to their resulting value.

 

[xlmate]

Hi,

My apology as I was away for the past week. I am still not sure what you are
trying
to achieve. Are you saying that when you change the referenced value in DL61
or
DM61, the value in DO61 doesn't change?

I tried this by changing the value and the resultant value does change.
If this is not what you are after, pls describe your data table and the
result you
want.

I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into
cell DO61. When I hit <enter>, the cell value shows "0.700" and the formula
bar shows "0.7". I'm trying to determine a Won/Lost percentage that will
re-calculate when I change the Won/Lost record. Obviously, if the formula is
replaced by the current value, changing the record will not change the
percentage.

would you elaborate on what you want to achieve?
do you want to show the result of the formula or you want to show
the formula itself?

What might cause, and how can I stop formulas from being automatically
converted to values? When I enter a formula into a cell, it is immediately
stored as the RESULT, not the actual formula. This is not consistent, even
with formulas that are "COPY-DOWN" [<Ctrl-D>] in the same column. Some
formulas remain and some convert to their resulting value.

 

[DJaded]

Quite simply, I would like the "value" in cell DO61 to a calculated
percentage based on cells DL61 and DM61. When I enter the necessary formlua
into cell DO61, the formula is immediately converted to the current value, as
if I had done a PasteSpecial-Values. Cell DO61 no longer contains the formula
- It contains the result!

Hi,

My apology as I was away for the past week. I am still not sure what you are
trying
to achieve. Are you saying that when you change the referenced value in DL61
or
DM61, the value in DO61 doesn't change?

I tried this by changing the value and the resultant value does change.
If this is not what you are after, pls describe your data table and the
result you
want.

I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into
cell DO61. When I hit <enter>, the cell value shows "0.700" and the formula
bar shows "0.7". I'm trying to determine a Won/Lost percentage that will
re-calculate when I change the Won/Lost record. Obviously, if the formula is
replaced by the current value, changing the record will not change the
percentage.

would you elaborate on what you want to achieve?
do you want to show the result of the formula or you want to show
the formula itself?

:

What might cause, and how can I stop formulas from being automatically
converted to values? When I enter a formula into a cell, it is immediately
stored as the RESULT, not the actual formula. This is not consistent, even
with formulas that are "COPY-DOWN" [<Ctrl-D>] in the same column. Some
formulas remain and some convert to their resulting value.

 

[xlmate]

I have tried this formula and its remain as formula in the cell.
Try checking the format of you cells by right clicking >> Format Cells >>
change it to General

Does this help? Pls click Yes if it does

cheers

Quite simply, I would like the "value" in cell DO61 to a calculated
percentage based on cells DL61 and DM61. When I enter the necessary formlua
into cell DO61, the formula is immediately converted to the current value, as
if I had done a PasteSpecial-Values. Cell DO61 no longer contains the formula
- It contains the result!

Hi,

My apology as I was away for the past week. I am still not sure what you are
trying
to achieve. Are you saying that when you change the referenced value in DL61
or
DM61, the value in DO61 doesn't change?

I tried this by changing the value and the resultant value does change.
If this is not what you are after, pls describe your data table and the
result you
want.

I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into
cell DO61. When I hit <enter>, the cell value shows "0.700" and the formula
bar shows "0.7". I'm trying to determine a Won/Lost percentage that will
re-calculate when I change the Won/Lost record. Obviously, if the formula is
replaced by the current value, changing the record will not change the
percentage.

:

would you elaborate on what you want to achieve?
do you want to show the result of the formula or you want to show
the formula itself?

:

What might cause, and how can I stop formulas from being automatically
converted to values? When I enter a formula into a cell, it is immediately
stored as the RESULT, not the actual formula. This is not consistent, even
with formulas that are "COPY-DOWN" [<Ctrl-D>] in the same column. Some
formulas remain and some convert to their resulting value.

 

[DJaded]

No, this does NOT help. The only thing that [partially] helps is to actually
DELETE the cells in the table and reapply the formula. However, when I post
new values to the source cells, the formulas are again converted to their
values.

Bottom line, though, is you have no answer to the original question, Right?

I have tried this formula and its remain as formula in the cell.
Try checking the format of you cells by right clicking >> Format Cells >>
change it to General

Does this help? Pls click Yes if it does

cheers

Quite simply, I would like the "value" in cell DO61 to a calculated
percentage based on cells DL61 and DM61. When I enter the necessary formlua
into cell DO61, the formula is immediately converted to the current value, as
if I had done a PasteSpecial-Values. Cell DO61 no longer contains the formula
- It contains the result!

Hi,

My apology as I was away for the past week. I am still not sure what you are
trying
to achieve. Are you saying that when you change the referenced value in DL61
or
DM61, the value in DO61 doesn't change?

I tried this by changing the value and the resultant value does change.
If this is not what you are after, pls describe your data table and the
result you
want.


:

I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into
cell DO61. When I hit <enter>, the cell value shows "0.700" and the formula
bar shows "0.7". I'm trying to determine a Won/Lost percentage that will
re-calculate when I change the Won/Lost record. Obviously, if the formula is
replaced by the current value, changing the record will not change the
percentage.

:

would you elaborate on what you want to achieve?
do you want to show the result of the formula or you want to show
the formula itself?

:

What might cause, and how can I stop formulas from being automatically
converted to values? When I enter a formula into a cell, it is immediately
stored as the RESULT, not the actual formula. This is not consistent, even
with formulas that are "COPY-DOWN" [<Ctrl-D>] in the same column. Some
formulas remain and some convert to their resulting value.

 

[xlmate]

My apology. The result did changed when I changes the value in source cells
using the your formula.

You may want to consider removing the TEXT function in your formula
"=IF(DL61+DM61=0,0,DL61/(DL61+DM61)) and format the result to 3 decimals

Why do you need to use the TEXT function in your formula?

Hope this help

No, this does NOT help. The only thing that [partially] helps is to actually
DELETE the cells in the table and reapply the formula. However, when I post
new values to the source cells, the formulas are again converted to their
values.

Bottom line, though, is you have no answer to the original question, Right?

I have tried this formula and its remain as formula in the cell.
Try checking the format of you cells by right clicking >> Format Cells >>
change it to General

Does this help? Pls click Yes if it does

cheers

Quite simply, I would like the "value" in cell DO61 to a calculated
percentage based on cells DL61 and DM61. When I enter the necessary formlua
into cell DO61, the formula is immediately converted to the current value, as
if I had done a PasteSpecial-Values. Cell DO61 no longer contains the formula
- It contains the result!

:

Hi,

My apology as I was away for the past week. I am still not sure what you are
trying
to achieve. Are you saying that when you change the referenced value in DL61
or
DM61, the value in DO61 doesn't change?

I tried this by changing the value and the resultant value does change.
If this is not what you are after, pls describe your data table and the
result you
want.


:

I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into
cell DO61. When I hit <enter>, the cell value shows "0.700" and the formula
bar shows "0.7". I'm trying to determine a Won/Lost percentage that will
re-calculate when I change the Won/Lost record. Obviously, if the formula is
replaced by the current value, changing the record will not change the
percentage.

:

would you elaborate on what you want to achieve?
do you want to show the result of the formula or you want to show
the formula itself?

:

What might cause, and how can I stop formulas from being automatically
converted to values? When I enter a formula into a cell, it is immediately
stored as the RESULT, not the actual formula. This is not consistent, even
with formulas that are "COPY-DOWN" [<Ctrl-D>] in the same column. Some
formulas remain and some convert to their resulting value.

 

[AlbertLiem]

I am not offerring a solution. Instead, I have the same problem, and from the
correspondence that followed this posting, I still do not see a solution.
Also, in my case the changing from formula to value seems to occur
"randomly", meaning it is OK after x number of calculations, then "puff" it
changed to a value.

Yes, "clear contents" of the cell allows you to write a formula, but then
the same thing as mentioned above, happens.

Can some one help, PLEASE? Either tell me what to do, or point where the
solution has been shown.

Thanks

Albert Liem

PS I have been using MSExcel 2003 for some time, and never saw this happen.
Now I use MS Excel 2007 and Vista. Prgress???!!!

 

[AlbertLiem]

I am not offering a solution. Instead I have the same problem, and have not
seen a solution in this series of correspondence or other places that I have
searched thus far.

HELP, please?

Note: I have used Excel 2003 for a long time and never saw this happen. Now
I use 2007 and VISTA. Progress, huh???!!!