When typing the formula be sure not to enter a space before the equals.
Double click the cell, or edit it in the Formula Bar. This is a common approach to store numbers such as phone numbers as text to retain the leading zeros.
This however could be the reason why your formula is not calculating.
If there is a space in the start of the formula then the program will not detect it as a formula and just as simple text, therefore, it will not update.
Also, sometimes there is an apostrophe at the start of the formula.
In this step, we are going to be changing that setting In some cases, it was found that if the cell format of your formula is set to “Text” instead of “General” then the formulas will not update.
Therefore, in this step, we will be changing the format of the Formulas.This can be helpful when troubleshooting formula problems.Simply click the Show Formulas button again to turn it off and the formula will be working.It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets.Excel forms part of the Microsoft Office suite of software.Your formulas are the driving force for your spreadsheet.