https://bugs.documentfoundation.org/show_bug.cgi?id=87386
--- Comment #11 from GerardF <[email protected]> --- (In reply to klsu from comment #0) > Cell C13 & D13 contain general number 24.09 and text 24.09.13, respectively > (European dates dd.mm and dd.mm.yy in a .CSV opened on a US machine). > Formula to convert the first dd.mm and the second year to a date would be > =DATE(2000+VALUE(RIGHT(D13,2)),MOD(C13,1)*100,INT(C13)), however, for this > particular date the formula returns 08/24/13 rather than 09/24/13. Note that: > =DATE(2000+VALUE(RIGHT(D13,2)),0.09*100,INT(C13)) works > =DATE(2000+VALUE(RIGHT(D13,2)),C13*100-INT(C13)*100,INT(C13)) works > =DATE(2000+VALUE(RIGHT(D13,2)),(C13-INT(C13))*100,INT(C13)) does not > =DATE(2000+VALUE(RIGHT(D13,2)),MOD(C13,1)*100,INT(C13)) does not > A similar problem occurs with number 7.05 and text 07.05.13 and others, > but not all. Instead of using DATE, VALUE, RIGHT, INT, MOD and other hundreds of Functions, just open correctly the .csv file and you will have true dates and don't need any functions. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
