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

Am 13.04.2015 um 10:56 schrieb bhaumikdave:
What ever the wordings are, conveying idea is important. I am not "The
Expert" but just want to solve the issue using more simpler method rather
than formulating some creepy scripts. 

Which script? You mean the ordinary, simple spreadsheet formula?

Can you accept that a general solution to the problem of wrongly
imported text data may be slightly more difficult than you think?
The original poster did not provide any technical information to his
particular problem and he did not respond to anybody. Therefore I
suggested a one-method-fits-all solution which involves a maximum of 6
simple steps:

1. adjust the locale setting if necessary
2. paste and adjust my spreadsheet formula into a cell
3. copy the formula down the column (double-click the cell handle)
4. paste-special resulting numbers over the wrong data
5. If 1. then switch back to your preferred locale
6. format to your liking

This will convert text dates as well as wrong dates (switched month and
day) in one go and won't take more than 30 seconds.

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.