Date returns always returns: 00 January 1900
 

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

Date returns always returns: 00 January 1900
 

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 wrote:

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

Date returns always returns: 00 January 1900
 

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

AW

"Dave Peterson" wrote:

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 wrote:

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