Date returns always returns: 00 January 1900

[ArcticWolf]

Hi,

I've formatted cell to - Number > Date>*14 March 2001

I type in todays date 11/9/08, but it returns 00 January 1900. If I type
the formula =today() then it returns the correct date in the correct format.

Any ideas why it wont return the correct format/date.

Thanks in advance,

AW

 

[Dave Peterson]

In xl2003 menus:
Tools|Options|Transition tab
Uncheck all those Lotus 123 options--especially "transition formula entry"

With that option checked, excel interprets your entry using Lotus 123 rules and
sees 11/9/2008 as =11/9/2008 (or 11 divided by 9 divided by 2008).

This is a small number that represents a time on that January 0, 1900 date.

 

[ArcticWolf]

Perfect, it works now - thanks for the swift reply Dave.

AW