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


At 21:05 26/10/2014 +0000, Alastair Noname wrote:
OK I now have the spaces and other marks sorted out. Not helped by the "Intelligent" quotation marking in libreoffice. I must find out how to turn off.

Tools | AutoCorrect Options... | Localized Options: untick Replace. Alternatively, just use Edit | Undo (or Ctrl+Z) immediately the correction occurs.

I used CONCATENATE and CHOOSE and now results look OK. Before I get round to clearing the working columns as you suggest I have a problem with date format which I have forgotten how I solved. In short the dates are in columns as such as "18 Sep 2015" without leading comma ...

Er, apostrophe?

... so they are numbers not text. However I cannot change the format.

If you cannot change the format, they are very likely text, not numbers, and therefore not true, adjustable-format dates. They will arrive as text from a CSV file unless you adjust the column types in the Text Import dialogue.

I think last time I did this I created another column with correct date format and used paste special to copy but this time it does not work. Any suggestions please?

Either:
o Adjust the column type to Date in the Text Import dialogue.
Or:
o Use =DATEVALUE() to derive a proper date value from what you have and format that.
Or:
o Use =TEXT(DATEVALUE(),"xxx") to derive a text version of your date, where "xxx" is the required format.

I trust this helps.

Brian Barker


--
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

Context


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.