Hello everyone. I was wondering if anyone has experienced my problem. I am working on a excel spread sheet, where I have a starting total ( my sales) and a long list of expenses. As I group the expenses together, such as Insurances, for example, that total I write it down on one column. The next column is where I have my total sales amount and that amount goes down as I deduct the expenses. I use a simple formula (=D123-C122) , which would be the total sales amount less the expenses, and the difference is supposed to appear on that cell, but it's not doing that anymore. It stopped. I checked the formula, it's correct, I cleared contents on that cell, to make sure there is nothing preventing it from showing my number, but it hasn't worked. If I click on the cell where the amount should appear, it shows the correct formula. I used the same formula on previous entries on the same sheet, and it worked. But now just shows the dollar sign and a little symbol like when the number is zero. But it CAN NOT be zero, since the correct amount would be a regular number. Anyone has experienced this?
