Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

Am 14.04.2015 um 07:03 schrieb bhaumikdave:
I am using US Locale i.e. (English) US so it uses dd-mm-yy format.

But your dates are in " mm-dd-yy"  format.  Inorder to convert 04-14-2015 to
14th April, 2015  , I need to change Date and Time settings from Control

I kept my US locale as it is and changed date format to "mm-dd-yy" and 
converted your dates as 13-April-2015, 14-April-2015, and so on. 

Hope this  is useful. 

View this message in context:
Sent from the Users mailing list archive at

Ah, you prefer using the Windows system panel for a simple text import?
Would you find that setting on a Mac?

And did you try out what Excel does when you do not adjust your system
settings? No? It will import text and/or wrong dates with twisted months
and days. Even the holy Excel is able to import wrong data when you are
unaware of system settings.

What is wrong with the locale setting right in front of your nose on the
_text_import_dialog_ of LibreOffice where you can choose anything
adequate without navigating the system panel?

If you know, that my dates had been exported in German, you can easily
13. Mai 2015|10.3256,98
Check "special numbers", German(Germany) language and | as column separator.

I agree that the "special mumbers" option is misleading (if not
obsolete) and that it should be checked by default, however ignoring any
options will lead to errors sooner or later. In fact this option remains
checked by default once it has been used. In the rare cases where this
option does the wrong thing, you may turn it of or explicitly mark the
column as "Text".

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.