Formulas disappearing from cell but result still there

[steminist2788]

Hello, I am having trouble with excel showing the resulting values of formulas that I have typed in but the formula has disappeared. The cells dependent upon the formula do not change when I change the number in the previous cell. Some of the formulas I am using are simple like 1+1=2. The cell will show the value (2) but not the formula (=1+1). Has anyone come across this? I am not using any macros, I checked in the Formulas tab to make sure the Hidden box is not checked. I tried hitting CTRL~ to show all formulas but those cells still just contain a value and not the formula. A lot of the work I am doing in this sheet is dependent on the value in another cell, but since the formulas keep disappearing, the values don't change when the other value is changed. Any ideas on how to help?

Thanks.

 

[Zot]

Check on the Status Bar at the bottom of the sheet. Check if you have circular reference. This may cause the problem. One of the formula in the sheet keep looping.

 

[steminist2788]

I downloaded a csv file and was working in that without saving it as an xlsx file first. That was why. Thanks for your response!

 

[Zot]

I downloaded a csv file and was working in that without saving it as an xlsx file first. That was why. Thanks for your response!

Aaaa... So far I have just imported data from csv. Did not know about that behavior.

I hate to not able to see file extension. That is why I make it visible on my PC

Thanks for update.