Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Formulas to Values

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default Formulas to Values

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.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 79
Default Formulas to Values

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.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Formulas to Values

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.




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Formulas to Values

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.



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default Formulas to Values

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.

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Formulas to Values

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.

  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default Formulas to Values

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.

  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Formulas to Values

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?

"xlmate" wrote:

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.

  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default Formulas to Values

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


"DJaded" wrote:

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?

"xlmate" wrote:

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.



  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Formulas to Values

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.

  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Formulas to Values

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keep Values and Formulas billinr Excel Worksheet Functions 0 October 16th 07 01:58 PM
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP Sherberg Excel Worksheet Functions 4 September 11th 07 01:34 AM
values in IF formulas Prima1 Excel Worksheet Functions 2 May 11th 06 04:51 AM
Formulas as Values Jack Brackson Excel Discussion (Misc queries) 3 July 29th 05 12:34 PM
Formulas with "Y" & "N" values Corey B Excel Discussion (Misc queries) 4 February 16th 05 01:49 AM


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"