Date Formatting Problem

  • Thread starter Thread starter Mehdi Shoja
  • Start date Start date
M

Mehdi Shoja

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.
 
Hi
why not format the cell/column with a different date
format. e.g.
DD-MMM-YYYY
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating occupational sick pay entitlement 0
Find Date in different format 1
Excel is changing date format incorrectly 7
Problems with date formats 4
Date time format 3
Why this paste result? 4
Time averaging raw data 3
Please help! date showing as 1900/01/00 2

Back
Top