ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2010 in Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/252444-2010-excel-2000-a.html)

BudW

2010 in Excel 2000
 
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 ?

Dave Peterson

2010 in Excel 2000
 
Any chance you have some data|validation that's stopping you?

What are you typing?
What is the exact message you see when it fails?

BudW wrote:

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 ?


--

Dave Peterson

Bob Phillips[_4_]

2010 in Excel 2000
 
In what context is it being used where it tells you this?


---
HTH

Bob Phillips

"BudW" wrote in message
...
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 ?





All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com