How do I format a cell to a date format?
 

I am trying to format cells to date formats. Even after I go to Format
Cells and choose the DATE format, the cell does not display the date when I
type it in. For example, I will type in 6/14/2003 and when I press enter the
cell reads, 37786. The date does appear in the formula bar though. How can
I fix this?

How do I format a cell to a date format?
 

Hi Trainer,

try to delete de format EDIT | CLEAR | FORMAT
and format it as a date again

HTH
regards from Brazil
Marcelo

"trainer07" escreveu:

I am trying to format cells to date formats. Even after I go to Format
Cells and choose the DATE format, the cell does not display the date when I
type it in. For example, I will type in 6/14/2003 and when I press enter the
cell reads, 37786. The date does appear in the formula bar though. How can
I fix this?