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.

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

"DJaded" wrote in message
...
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.

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.

"Bernard Liengme" wrote:

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

"DJaded" wrote in message
...
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.

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" wrote:

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.

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.

"franciz" wrote:

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" wrote:

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.

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.


"DJaded" wrote:

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.

"franciz" wrote:

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" wrote:

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.

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!

"xlmate" wrote:

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.


"DJaded" wrote:

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.

"franciz" wrote:

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" wrote:

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.

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


"DJaded" wrote:

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!

"xlmate" wrote:

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.


"DJaded" wrote:

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.

"franciz" wrote:

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" wrote:

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.

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

"DJaded" wrote:

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.

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

"DJaded" wrote:

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.