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.