[libreoffice-users] Re: converting txt to dates

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
> panel. 
>
> 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: 
> http://nabble.documentfoundation.org/converting-txt-to-dates-tp4143826p4146198.html
> Sent from the Users mailing list archive at Nabble.com.


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
import
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: users+unsubscribe@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