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