the date will not appear in the cell

K

keith r. bunn sr.

In Excel template that I am customizing the date will not appear after
inserting it. It's there but will not appear. I have tried formating but that
don't work. HELP
 
G

Gary's Student

It is possible for data to appear in the formula bar, yet not appear in the
cell.

The first reason is the data may be interpreted as text and have many
leading blanks.

The second reason is that the font may have the same color as the background.
 
D

Dave Peterson

A couple more reasons...

The cell has format|conditional formatting applied and the fill and font color
are the same.

The cell has a format of ";;;" without the quotes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top