Forum Discussion
LINDA1259
Aug 09, 2020Copper Contributor
WHY HAVE FORMULAS STOPPED WORKING IN 2020 EXCEL FOR BUSINESS
UPPER =UPPER(B2) The formulas displays but will not calculate. I think I check all the places that would cause this and do not find a selection that would just show the formula. W...
HansVogelaar
Aug 09, 2020MVP
- Make sure that the cells with formulas are NOT formatted as Text, but for example as General.
- Make sure that 'Show Formulas' has NOT been selected in the 'Formula Auditing' group of the Formulas tab of the ribbon.