Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yesterday I encountered a problem with Excel formulas. Several cells began to
display the formula instead of the result on one of my spreadsheets. My formula was simple: =$f$1 Instead of displaying the value of F1, it actually displays "=$F$1" Reviewing the posts from yesterday, I count 4 people posting with the EXACT SAME PROBLEM. The symptoms are the same. Cells display the formula instead of the result. NONE of the proposed solutions help. I know most of the settings for Excel so I checked the obvious: Are cells set to calculate automatically: YES. In the view settings are formulas checked for display: NO. Is there a formula error that causes the formula to be displayed (extra =): NO Several people proposed checking whether the format was set to text: FORMATTING AS TEXT IS NOT SUPPOSED TO DISPLAY FORMULAS!! Formatting as text should display the formula RESULTS AS TEXT! Why are so many people suddenly having this problem? Was there a recent update to Excel that could affect this? Is there a coding error that somehow was triggered by the date? Is there anyone who can get to the bottom of this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
allow users to edit a range in excel 2000 | Excel Discussion (Misc queries) | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions |