Hi, the date 01-Jan-1900 and 01-Jan-2000 both are
displayed as 01-Jan-00 by Excel when downloading a ASP
page business report (by programming it) into Excel.
Apparaently, the Excel makes the final decision by
reformatting the specified and inserted date 01-Jan-1900
and displaying it as 01-Jan-00 causing confusion with 01-
Jan-2000 which again the Excel would display as 01-Jan-00.

I must say that the data passed into Excel is correct but
the displayed format is driven by Excel.

has anybody got any suggestion os solution to this
problem? Please let me know if you need more explanation.