I’m having trouble converting an imported field that has YYYY-MM-DD HH:MM:SS to just YYYY-MM-DD. I’m using version 126.96.36.199.
Example: cell contains 2022-12-09 00:49:10
I used Format/Cells/Date/Format 1999-12-31. Format Code is YYYY-MM-DD, and it shows ISO 8601. Result: In the cell itself, nothing has changed. The line where you can see the actual data (not sure what that’s actually called) shows the same data with a single quotation mark in front of it('2022-12-09 00:49:10). If I manually remove the single quotation mark, the date formats correctly. However, because I have a whole bunch of cells that need reformatting, I’m trying to find a better solution than one ata time.
I tried Find and Replace, with Find '2, Replace 2, but it didn’t find it.
According to Help, the Format Cell function should work.
What am I doing wrong… or… is there some trick?