ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I can see text in the formula bar, but not in the cell. (https://www.excelbanter.com/excel-discussion-misc-queries/107818-i-can-see-text-formula-bar-but-not-cell.html)

dan

I can see text in the formula bar, but not in the cell.
 
There are no words showing in the cells, yet they show in the formula bar.

Trevor Shuttleworth

I can see text in the formula bar, but not in the cell.
 
Maybe the text and the background are the same colour ? White perhaps ?

Select all the text in the sheet and choose automatic for the font colour.

Ctrl-A

Format | Cells... | Font tab | Colour: Automatic

Regards

Trevor


"Dan" wrote in message
...
There are no words showing in the cells, yet they show in the formula bar.




Gord Dibben

I can see text in the formula bar, but not in the cell.
 
Maybe they are formatted as Custom ;;;


Gord Dibben MS Excel MVP

On Wed, 30 Aug 2006 22:38:30 +0100, "Trevor Shuttleworth"
wrote:

Maybe the text and the background are the same colour ? White perhaps ?

Select all the text in the sheet and choose automatic for the font colour.

Ctrl-A

Format | Cells... | Font tab | Colour: Automatic

Regards

Trevor


"Dan" wrote in message
...
There are no words showing in the cells, yet they show in the formula bar.





All times are GMT +1. The time now is 10:48 PM.

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