excel for mac 16 cell no text disappears

Clean up that cell. No. 5. You have in a cell, but its format is set to Fill.

Clicking in the cell makes it visible again--but only until you leave.

Ive found a lot of threads that discuss various aspects and manifestations of the problem.

It could mean a few things.

The columnwidth is too narrow to show the number.

Or change the numberformat to General.

You have a datetime in that cell and its negative Dont use negative dates.

If excel was helping you, it may have changed the format to a date.

If you need to see negative datetimes: ToolsoptionsCalculation Taband check 1904 date system (but this can cause trouble--watch what happens to your dates and watch what happens when you copypaste dates to a different workbook that doesnt use this setting) 3.

You have a lot of text in the cell, the cell is formatted as Text.

Format the cell as general.

You really have s in that cell.

Clean up that cell.

You have in a cell, but its format is set to Fill.

Change the format (formatcellsalignment tabhorizontal box, change it to General.

Shannon Jacobs wrote: Actually, the text hasnt gone anywhere, but it just becomes invisible or turns into a row of XXXXs when you leave the cell.

Anyone able to explain whats going on here Yet another fix -- Dave Peterson.

No. I said text. 2.

I said text. 3. You have a lot of text in the cell, the cell is formatted as Text.

Tried both. 4. You really have s in that cell.

No. 5. You have in a cell, but its format is set to Fill.

Excel For Mac 16 Cell No Text Disappears