Cell Format
 

In a predesigned workbook, I was entering a date in a cell but it would
default to the general format. I tried changing the format in the cells
dialog box but it still displays as a general format. The date displays in
the formula bar as a date, but not in the cell. How do I get the cell to
display the date format that I want?

Cell Format
 

Could be you are in "Formula View"

CTRL + `(backquote) to toggle on/off


Gord Dibben MS Excel MVP

On Wed, 14 Apr 2010 04:43:01 -0700, Angelo
wrote:

In a predesigned workbook, I was entering a date in a cell but it would
default to the general format. I tried changing the format in the cells
dialog box but it still displays as a general format. The date displays in
the formula bar as a date, but not in the cell. How do I get the cell to
display the date format that I want?