LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default Excel date displayed wrongly

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;
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas calculate the answer wrongly as 0 Mary P Excel Worksheet Functions 1 December 8th 08 05:52 PM
DATE WRONGLY TYPED IN NUMBER FOMRATE Danish Raj Excel Discussion (Misc queries) 1 September 7th 06 08:45 AM
wrongly added or subtracted decimals ornithology 1 Excel Discussion (Misc queries) 2 January 15th 06 10:49 PM
Time displaying wrongly Denise Robinson Excel Discussion (Misc queries) 3 August 9th 05 02:30 PM
sorry i put wrongly for padded leading 0 tango Excel Programming 1 November 12th 04 12:22 AM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"