Date returns always returns: 00 January 1900

A

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top