Tag: formatting
-
LibreOffice Calc automatic date formatting workaround
I was given a spreadsheet .xlsx file which had dates formatted as “YYYY-MM-DD HH:MM:SS” and I could not figure out how to get LibreOffice Calc to stop formatting it as a date while preserving the date. When I formatted it as text it became a FLOAT number, but that’s not what I wanted. So the…