ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Why are my numbers disappearing in excel yet it totals them? (https://www.excelbanter.com/excel-worksheet-functions/250035-why-my-numbers-disappearing-excel-yet-totals-them.html)

Donna Stevens

Why are my numbers disappearing in excel yet it totals them?
 
I have a spreadsheet that I have filled out the individual cells with number.
These cells are totaling correctly, however when I open the spreadsheet
the individual number I entered are showing blank.... I moved my mouse
around in the spreadhsheet and all of a sudden the numbers appeared and then
disappeared.

ADB_Seeker

Why are my numbers disappearing in excel yet it totals them?
 
Check the font color. The default is black.
Also check the cell color. Default is "no fill".
If the font color was changed to white, you would only see the content after
you select the cell.

Remember to Click Yes, if this post helps!


"Donna Stevens" wrote:

I have a spreadsheet that I have filled out the individual cells with number.
These cells are totaling correctly, however when I open the spreadsheet
the individual number I entered are showing blank.... I moved my mouse
around in the spreadhsheet and all of a sudden the numbers appeared and then
disappeared.



All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com