Date format doesn't work? [closed]
I set a column to be date format YYYY-MM-DD but if I put in July 14, 2015 it doesn't convert it. What am I doing wrong?
First time here? Check out the FAQ!
I set a column to be date format YYYY-MM-DD but if I put in July 14, 2015 it doesn't convert it. What am I doing wrong?
You need to enter the date in a format that Calc will recognise as a date - starting with July causes Calc to interpret the input as text.
See sections 2 and 3 of this article for more information.
If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.
"starting with July causes Calc to interpret the input as text" actually is not true, but it depends on the locale what strings are recognized as dates. In an English-US locale July 14, 2017 is perfectly recognized as date, but in a non-English locale of course it is not.
Asked: 2017-07-18 04:32:47 +0100
Seen: 728 times
Last updated: Jul 18 '17
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]