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
|