View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Excel date displayed wrongly

Is the data you loading in the correct format?

Also check the format of the cells on the worksheet by clicking on cell then
going to menu Format - Cells - Number Format and seeing how the cell is
formated.

You have to be able to isolated the problem in the add-in where the problem
is occuring.

"mahesh" wrote:

when I load data to spreadsheet through add-in to the spreadsheet having
dates in the european format - dd/mm/yyyy and number format as *dd/mm/yyyy it
is displyed wrongly (i.e. my source date is 08/10/2008 as general/text and
the data displyed in Excel sheet cell having date format as mentioned above
is 10/08/2008)



This works fine when date(09) is greater than month (08) (i.e. 09/08/2008)
or format is yyyy-mm-dd in regional setting

I don't find any problem in addin;