Hi :) I find that is often the way too. It's a bit contra-intuitive to type-in a / when you know you want it to display a - and that makes it very hard to explain to people that need to enter data into your spreadsheet. Saying it's the same in Excel doesn't help. Regards from Tom :) --- On Mon, 23/7/12, MiguelAngel <mariosv@miguelangel.mobi> wrote: <snip /> And maybe is refined to be interpreted as date using the system separator, the same separator as in the date cell format. In my Spanish Winx64Ult: / If I enter: 20/7 I get: 20/07/12 If I enter: 20-7 I get: 20-7 (text) Miguel Ángel * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano <javascript:void(0);> -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted