[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-users] full date string to date



On 2019-12-30 4:43 p.m., Alan B wrote:
James,

The only way I could get the text sample you provided to be accepted as a date was to leave the day name off. Typing Wed, Jan 2, 2020 into a cell resulted in a cell that contained text. Typing Jan 2, 2020 into a cell resulted in a cell that contained a date in the default date format, mm/dd/yy. That could then be formatted to NN, MMM D, YYYY and display as Wed, Jan 2, 2020.

The DATEVALUE() function will convert the string Jan 2, 2020 to a date. It returns Err:502 when pointed at the string Wed, Jan 2, 2020.

My suggestion would be to input the substring Jan 2, 2020 into the DATEVALUE function then format as desired to get your dates back.

e.g. =DATEVALUE(MID(A1,6,20))

That works, thanks.

I have a spreadsheet with 2018 dates and I did a replace of '2018' for '2019' to make a copy of the spreadsheet for 2019.
When I did the replace for 2020 dates it changed the cells to text.
I maybe had an option checked that I didn't before. :-(



On Mon, Dec 30, 2019 at 2:55 PM James <bjlockie@lockie.ca <mailto:bjlockie@lockie.ca>> wrote:

I had a spreadsheet with dates that I think somehow got converted
to text.
I tried pasting it as plain text with detecting special numbers and I
tried setting the column to a date format but it still seems to
come out
as text.

'Wed, Jan 2, 2020'


-- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
<mailto:users%2Bunsubscribe@global.libreoffice.org>
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



--
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

References:
[libreoffice-users] full date string to dateJames <bjlockie@lockie.ca>
Re: [libreoffice-users] full date string to dateAlan B <aboba0@gmail.com>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.