| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Formatting Problem
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Formatting Problem | New Users to Excel | |||
| Date Formatting Problem | Excel Discussion (Misc queries) | |||
| Date formatting problem | Excel Discussion (Misc queries) | |||
| Date formatting problem | Excel Discussion (Misc queries) | |||
| Problem with Date Formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
