Am 14.04.2015 um 07:03 schrieb bhaumikdave:
I am using US Locale i.e. (English) US so it uses dd-mm-yy format.
But your dates are in mm-dd-yy format. Inorder to convert 04-14-2015 to
14th April, 2015 , I need to change Date and Time settings from Control
panel.
I kept my US locale as
Am 21.04.2015 um 22:44 schrieb Joel Madero:
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
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
Yes It is 12-April-2015.
I am using US Locale i.e. (English) US and it shows 12-04-2015 as
12-April-2015.
--
View this message in context:
http://nabble.documentfoundation.org/converting-txt-to-dates-tp4143826p4146197.html
Sent from the Users mailing list archive at Nabble.com.
--
To
I am using US Locale i.e. (English) US so it uses dd-mm-yy format.
But your dates are in mm-dd-yy format. Inorder to convert 04-14-2015 to
14th April, 2015 , I need to change Date and Time settings from Control
panel.
I kept my US locale as it is and changed date format to mm-dd-yy and
What ever the wordings are, conveying idea is important. I am not The
Expert but just want to solve the issue using more simpler method rather
than formulating some creepy scripts.
--
View this message in context:
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
Hi, I got a simple solution to this. My date format in excel sheet was like
12-04-2015.
Excel was not recognizing it as date or Formatting cell to Date was helping
me.
So I selected and Copied entire column of date to New Blank Word document.
Then I Again copied the date column from word
Am 13.04.2015 um 15:54 schrieb James Knott:
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.
Am 13.04.2015 um 08:58 schrieb bhaumikdave:
Hi, I got a simple solution to this. My date format in excel sheet was like
12-04-2015.
Excel was not recognizing it as date or Formatting cell to Date was helping
me.
So I selected and Copied entire column of date to New Blank Word document.
Am 13.04.2015 um 08:58 schrieb bhaumikdave:
Hi, I got a simple solution to this. My date format in excel sheet was like
12-04-2015.
Excel was not recognizing it as date or Formatting cell to Date was helping
me.
So I selected and Copied entire column of date to New Blank Word document.
Am 13.04.2015 um 15:54 schrieb James Knott:
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.
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
Am 13.04.2015 um 10:56 schrieb bhaumikdave:
What ever the wordings are, conveying idea is important. I am not The
Expert but just want to solve the issue using more simpler method rather
than formulating some creepy scripts.
Which script? You mean the ordinary, simple spreadsheet
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
Am 13.04.2015 um 16:22 schrieb Andreas Säger:
Am 13.04.2015 um 08:58 schrieb bhaumikdave:
Hi, I got a simple solution to this. My date format in excel sheet was like
12-04-2015.
Excel was not recognizing it as date or Formatting cell to Date was helping
me.
So I selected and Copied entire
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
Am 25.03.2015 um 01:28 schrieb Kaj:
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
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
the date acceptance pattern: besides
Andreas Säger wrote
All this conversion from strings to numbers is unrelated to the date
acceptance patterns that determines how Calc turns your keyboard input
into day numbers.
No, it is not just for keyboard entry! And, it is certainly applicable for
format conversion of non-local date
Am 20.03.2015 um 02:28 schrieb James:
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
14/03/2015Err:502
=DATEVALUE(TEXT(A1,##/##/))
=DATEVALUE(A2)
Short
Am 24.03.2015 um 20:09 schrieb V Stuart Foote:
Andreas Säger wrote
All this conversion from strings to numbers is unrelated to the date
acceptance patterns that determines how Calc turns your keyboard input
into day numbers.
No, it is not just for keyboard entry! And, it is certainly
Am 20.03.2015 um 12:21 schrieb Kaj:
No, this won't work. You've got to change the global locale option in
order to change the evaluation context for existing data.
Other method: =DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2))
Do you have the used date pattern defined? Look at (menu) - Tools -
If DATEVALUE(A2) is giving an error, maybe there is something else in the
cell, or you are using English-US as language then it is an invalid date,
month=14?
You can also try with Menu/Data/Text to column after select the data, click
on column head and select in column type the day type.
Miguel
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
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
14/03/2015Err:502
Am 20.03.2015 um 12:21 schrieb Kaj:
Do you have the used date pattern defined? Look at (menu) - Tools -
Language Settings - Languages at Date acceptance patterns.
No. Do you?
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
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
Off topic...
Thomas Taylor wrote
Please leave original context in replies. Stripping original content
makes it
more difficult to track conversations without going back through the
entire
message thread.
Nope--not at all necessary, and in many cases an indiscriminate lack of
trimming makes
37 matches
Mail list logo