Adam Tauno Williams wrote:
=DATEVALUE($CELL) will convert a text representation of a date to a date value.
No, it won't unless you set the application locale in the options to something that matches the assumed date format in the text values.
Usually people import from csv using the wrong locale and get a wild mixture of text and wrong dates with switched month and day.
1/2/99 => 1st of February vs. Jan, 1st 1/31/99 is not a valid date unless you interprete it in US context. This is hard to fix. First apply the right locale in the language options. Then switch back day and month for all numbers and convert text: =IF(ISNUMBER(A1);DATE(YEAR(A1);DAY(A1);MONTH(A1) ; VALUE(A1)) --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
