Created attachment 105384 [details] French spellchecker converts "aout 2014" into number English-GB using France-France spellchecker. Column format set to numeric 0 or 2 decimal places. Aout 2014 spelling error is "corrected" to "2014-08-01" 0 decimal places and "41852,00" Expected behaviour, error should be corrected to "Août 2014" Bypass - spell the French Month correctly and not use spellchecker. Same error with 4.2.6 have not access to Windows or Mac to try them. 4.3.1 aborted calc. Attached extracted spreadsheet of this peculiar problem..Peter
Hi Peter, Set your cells to text format if you want to keep such contents once corrected. Else, Calc convert them automatically to date in the first form with standard number format and in the second form with two decimals. This last one is also the internal format to keep date, with the integer part as the total number of days since 12/30/1899 and fractional part as fractional portion of a day. regards, Jacques
Hi Jacques, Thank you for your clear explanation. I had the column, not the cell set to text. As the small spreadsheet created for an English woman is being presented to the local, but friendly Mayor of our French village, it was important for us, but not for him, to have any French accents correctly applied. I accept it is user error notabug. Regards Peter
Delighted if that could help you. Jacques