Unwanted conversion of formulas to values

[sandik]

My formulas keep converting to values after saving and closing a spreadsheet, then reopening them. Is there an setting I need to change? Thanks.

 

[sandik]

This is for Excel 2010.

 

[billgyrotech]

Please attach a formula so we can see how to correct.

place your code like this:

    your code

 

[sandik]

Please attach a formula so we can see how to correct.

place your code like this:

    your code

I don't know how to use code, but the formula is very basic:

=S19*2

Thank you.

 

[FDibbins]

Do you know if there is any code/VBA/macro running in the back ground?
What is the file extension?

There is no way that a formula will just "convert" to it's answer, without something acting on it

Also, you don't need any "code" to paste a formula here, what you did was just fine

 

[billgyrotech]

It seems you have a calculation which will result in a value. Isn't that what you want?

To put a code here you can do it like this:

(code)
your code
(/code)

Replace the parenthesis with square brackets.

 

[FDibbins]

There is no calculation which will just convert to a value, replacing the formula with it's answer. Something else must be at work here

 

[sandik]

I think I just found the problem. I had to download the data in .csv format from another program. So if I convert to .xlsx, will that solve the problem?

 

[billgyrotech]

Yes that should solve your problem. It seems a shame that we cannot attach files here to actually show in detail what is going on. Good luck!

 

[FDibbins]

OK so the formula was just being overwritten by the new download. Perhaps put the formula/s further over, or on another sheet and run from there?