steminist2788
New Member
- Joined
- Mar 29, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
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.
Thanks.