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: [email protected]
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
