Updating microsoft excel
What I found to be the problem was the formula and the fact that I surrounded numbers with quotes.
That probably turned the cell into a text format cell, even though technically the cell was still a number and listed as one under the formats.
My solution was to find an old version of the same excel spreadsheet which was not having thses issuesbefore I archived it, which is of similar size and complexity to the current version.
But there are times you may find that the Excel Formulas are not updating automatically.
It can be very frustrating when your formulas are not updating automatically on Excel.
The second option is to go to the Microsoft Office website and download the Service Pack that corresponds to your version of Office.
You will be redirected to the Microsoft Download Center. In both cases, you may need to restart your computer for the update to be taken into account.