| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
incorrect Format Date mm/yyyy in excel 2003
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| Help with date format mm/dd/yyyy vs. dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
| opening excel file - date format problem: DD/MM/YYYY vs MM/DD/YYYY | Excel Programming | |||
Linear Mode
