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

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