| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
the date will not appear in the cell
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 -- krb sr |
|
#2
|
|||
|
|||
|
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. -- Gary's Student "keith r. bunn sr." wrote: 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 -- krb sr |
|
#3
|
|||
|
|||
|
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. keith r. bunn sr. wrote: 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 -- krb sr -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
| Return a date 6 months from a date in another cell | Excel Worksheet Functions | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
| cell assumes wrong date | Setting up and Configuration of Excel | |||
Linear Mode
