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
At 14:39 30/12/2019 -0500, James Lockie 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'
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,
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: