I have a spread sheet that the forumla quit calculating and displaying properly. Column A is a date and shows up just as numbers in the cell but in the fx box the date format is diplayed. The cell is formatted to date but still shows up as a number, next all the calculation format are set as numbers but the formula display as if it is in a text format =s4-t4. I have tried to re-enter the formulas and still nothing worked. The other worksheets in this workbook are still working correctly, and this work sheet has worked fine until yesterday.
Bookmarks