Prev: leading zero
Next: IF formula with multiple data range in cell
From: BudW on 5 Jan 2010 11:49
It appears that Excel 2000 does not like any year after 2009, as it tells me
date is invalid. Is there a way to fix this ?
From: Niek Otten on 5 Jan 2010 11:55
What exactly do you do? Enter a date or use a date in a formula? What date?
What is the error message? What date system is your Windows using
(dd/mm/yyy, mmm dd yy, etc) for Long date and Short date?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"BudW" <BudW(a)discussions.microsoft.com> wrote in message
news:FFC7EFFE-E536-492B-BCA2-6368E2C34F96(a)microsoft.com...
> It appears that Excel 2000 does not like any year after 2009, as it tells
> me
> date is invalid. Is there a way to fix this ?

From: Harald Staff on 5 Jan 2010 11:59
Follow up the questions asked to your previous identical post and the
chances will improve.

Best wishes Harald

"BudW" <BudW(a)discussions.microsoft.com> wrote in message
news:FFC7EFFE-E536-492B-BCA2-6368E2C34F96(a)microsoft.com...
> It appears that Excel 2000 does not like any year after 2009, as it tells
> me
> date is invalid. Is there a way to fix this ?

 | 
Pages: 1
Prev: leading zero
Next: IF formula with multiple data range in cell