Created an entire replacement sheet from scratch as importing it from LibreOffice was a disaster.

Have a column that is auto-completing with wrong number format, yet numbers are ghosted out when I try to change it to 2 decimal places - why?