Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas calculate the answer wrongly as 0 | Excel Worksheet Functions | |||
DATE WRONGLY TYPED IN NUMBER FOMRATE | Excel Discussion (Misc queries) | |||
wrongly added or subtracted decimals | Excel Discussion (Misc queries) | |||
Time displaying wrongly | Excel Discussion (Misc queries) | |||
sorry i put wrongly for padded leading 0 | Excel Programming |