View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ArcticWolf ArcticWolf is offline
external usenet poster
 
Posts: 70
Default 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