incorrect Format Date mm/yyyy in excel 2003

P

paracio

Hi,

I've application in vb.net to generate around 20 reports in excel
2002, most of report have date value in ddiffrent format. like
dd/mm/yyyy and mm/yyyy, the format put in excel template.
the regional setting of client is ENglish(US) with date format
dd/mm/yyyy.
with Excel 2002, the the date format displayed correctly
eg :
- JuL 1st 2005 : 01/07/2005 or 07/2005 (for format mm/yyyy)

last month the user upgrade their Excel, from excel 2002 to excel 2003
SP1.
and With EXCEL 2003 the format date displayed incorrectly :
- JuL 1st 2005 : 07/01/2005 or 01/2005 (for format mm/yyyy)


IS this bug from Excel 2003 ?

TIA,
Lucas
 

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

How to add day to PWA 2016 date format? 0
International Date formatting 6
Date Formats 4
Forcing a date entry format of dd/mm/yyyy 1
Date formatting issue VB 0
Date format problem 1
How to enter a date in DD-MM-YYYY format 2
Date formatting 1

Top