yyyymmdd is not a valid excel date format, excel needs date deimiters or else
it will treat it as a number.. Excel year zero started on Jan 0 1900 so if you
put 0 in a cell it will return 01/00/1900, 1 will be 01/01/1900

If you get a date in yyyymmdd format, select it, do datatext to columns and
click next twice, select Date under column data format and from dropdown
select YMD
and click finish and it will be converted to a real excel date

Regards,

Peo Sjoblom


"DP NY10601" wrote:

I have a date fiels yyyymmdd which can have a value of 0 or a valid date in
recent past.
Excel displays the 0 date as 01/01/1900 and the non zero dates as expected.

Cant figure this out , any help would be appreciated.