How do I format a cell to a date format?

T

trainer07

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?
 
M

Marcelo

Hi Trainer,

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

HTH
regards from Brazil
Marcelo

"trainer07" escreveu:
 
Top