Glaswegian
10-08-2012, 06:14 AM
Hi
I have data from our systems that is causing me some problems.
The date column appears to be behaving as if it is a Julian date - but I don't think it is really a Julian date.
For example, the date format is dd-mmm-yy - 31-Dec-29.
As long as the date year is less than 30 then Excel sees it as the correct century - in the example above Excel sees the year as 2029 - which is correct. However, if the year value is 30 or more, Excel sees it as 20th Century. For example, 31-Mar-30 is interpreted as the year 1930 when it should be 2030.
This is Julian date behaviour to me but I can't understand it and I cannot work out how to convert the dates to a standard format that shows correctly.
Thanks for any help.
I have data from our systems that is causing me some problems.
The date column appears to be behaving as if it is a Julian date - but I don't think it is really a Julian date.
For example, the date format is dd-mmm-yy - 31-Dec-29.
As long as the date year is less than 30 then Excel sees it as the correct century - in the example above Excel sees the year as 2029 - which is correct. However, if the year value is 30 or more, Excel sees it as 20th Century. For example, 31-Mar-30 is interpreted as the year 1930 when it should be 2030.
This is Julian date behaviour to me but I can't understand it and I cannot work out how to convert the dates to a standard format that shows correctly.
Thanks for any help.