Numbers not showing on my excel sheet

Occasional Visitor

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? 

4 Replies

@eliane2021 Please upload a screenshot so that we can see what you are experiencing. Difficult to envisage what "little symbol" you see.


You mention a 'simple' formula


I tend to describe such normal spreadsheet formulas as 'primitive' because the result of using the 'house of cards' built from the formula can be anything but simple.  Basic worksheet operations like 'drag and drop' or deleting rows can disrupt the formula.


I would suggest repairing the formula by sending it down the entire column is necessary before you can trust any result it provides.  Other approaches include the use of SUMIFS to sum the expenses over all earlier dates but that gets computationally expensive if you go beyond a few thousand lines. 

Fiz uma tabela com os dados geográficos de uma determinada região, mas quando incluii o Mapa pela aba inserir a proporção entre as áreas estão fora de escala. Como corrigir este erro? Ex: A área com maior área aparece menor do que as outras com menor área. No aguardo da resposta. Grato.


Could you please press Ctrl+1 on this cell and share with us which format is applied to it. It's here