lease make sure you don'w have manual calculations on (Tools, Options,
Calculation)

Make sure it's on Automatic.

If you have Excel 2003, you may see a yellow indicator. Highlighting over it
would allow you to convert to date.

Last thought, how are you entering the date?

"Riptide" wrote:

I enter a date and instead a get a number that doesn't seem to correspond
with the date. The cells are all formatted for the date function, but it
still won't show the date.