On 26/10/14 21:36, Brian Barker wrote:
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
Hi Brian,
Yes, apostrophe sorry.
DATEVALUE, that was it.
Many thanks once more.
Will report back if problems, else thanks again,
Budgie
--
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
