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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Formatting Problem
Hi
why not format the cell/column with a different date format. e.g. DD-MMM-YYYY -----Original Message----- 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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Formatting Problem
Thanks for the reply. I am not too sure how to format
the cell/column from within the ASP page? I write the code in ASP page and build the excel report using Stream object as follows: With vStream .WriteText "<HTML", C_adWriteChar .WriteText "<BODY", C_adWriteChar .WriteText "<TABLE border=1", C_adWriteChar |
Reply |
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) |