Re: [libreoffice-users] Help with Conditional Macro Please

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