bhaumikdave wrote on 13-04-15 08:58:
Done. Now Excel will recognize it as date and will allow you to format cells
any date format as you wish.
No idea what Excel does or not or what proper date handling would be
most ideal.
You may try this one however ;)
On Tue, Apr 21, 2015 at 12:19 PM, Cor Nouws oo...@nouenoff.nl wrote:
bhaumikdave wrote on 13-04-15 08:58:
Done. Now Excel will recognize it as date and will allow you to format
cells
any date format as you wish.
No idea what Excel does or not or what proper date handling would be
most
Hi Joel,
Joel Madero wrote on 21-04-15 22:44:
On Tue, Apr 21, 2015 at 12:19 PM, Cor Nouws oo...@nouenoff.nl wrote:
I think we should make this an easy hack to get it into core.
https://bugs.documentfoundation.org/show_bug.cgi?id=33962
The question comes up relatively frequently and many
Hi :)
I think you meant Writer rather than Word! Also Calc rather than
Excel. However those sorts of tricks often work in all sorts of
different Office suites. I would probably have used a text-editor rather
than W* to avoid any weird formatting creeping in but you did the same by
paste-special
On 04/13/2015 10:16 AM, Andreas Säger wrote:
But nobody does. Not my bank from where I import account statements,
yahoo finance, amazon, ebay, you name it.
Well, I often see it, particularly on government forms. On the other
hand, I have often seen dates and wondered what format it was, as
On 04/13/2015 09:38 AM, Andreas Säger wrote:
This __happens__ to work for you. What does 12-04-2015 actually mean?
On my system this will be interpreted as 12th of April. People with US
locale will get a date value referring to the 4th of December.
That is why people should be using only the
On 04/13/2015 12:30 PM, Tom Davies wrote:
They prefer to have everything
from August waaay before anything from March.
Another thing that adds to the fun is the 12 hour clock, so that 12:59
AM is before 1:00 AM. Of course, another bit of nonsense is 12 AM or
PM. The precise moment of 12:00 is
James Knott wrote:
For example, I am posting this at 2005 04 13 12:37. There is absolutely
no doubt as to when that is.
Except for the time zone :)
--
Piet van Oostrum p...@vanoostrum.org
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]
--
To unsubscribe e-mail to:
On 04/13/2015 12:37 PM, James Knott wrote:
For example, I am posting this at 2005 04 13 12:37. There is absolutely
no doubt as to when that is.
Ooops!!! Typo. That should be 2015, not 2005.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
On 04/13/2015 12:46 PM, Piet van Oostrum wrote:
For example, I am posting this at 2005 04 13 12:37. There is absolutely
no doubt as to when that is.
Except for the time zone :)
If relevant, then specify.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Hi :)
I use it quite a lot.
It makes sorting files a lot easier. If all files were created or modified
on the date that is most relevant to the contents of the file then it would
be quite simple but life is seldom that simple ime.
Of course no-one in my office understands. They prefer to have
Hi !
Now you happened to use the wrong conversion function, VALUE instead of
DATEVALUE, so of course it did not work. But even with the correct
function there seems to be some issues. According to the help text for
the date acceptance pattern: besides local ways to write date, also the
ISO
Am 2015-03-24 18:22, Andreas Säger schrieb:
Am 24.03.2015 um 14:22 schrieb Kaj:
Hi !
Now you happened to use the wrong conversion function, VALUE instead of
DATEVALUE, so of course it did not work. But even with the correct
function there seems to be some issues. According to the help text for
DO 2015-03-20 12:00, Andreas Säger wrote:
Am 20.03.2015 um 05:56 schrieb Emil Payne:
On 19/03/15 08:28 PM, James wrote:
Column A has text strings that are DD/MM/ format.
I want to make them real dates.
I tried these 2 datevalue formulas but I can't make it work.
14/03/2015Err:502
On Fri, 20 Mar 2015 12:00:02 +0100
Andreas Säger ville...@t-online.de wrote:
Am 20.03.2015 um 05:56 schrieb Emil Payne:
On 19/03/15 08:28 PM, James wrote:
Column A has text strings that are DD/MM/ format.
I want to make them real dates.
I tried these 2 datevalue formulas but I can't
15 matches
Mail list logo