Setting the cell format fixes it … until you save as .csv! Then it reverts back. Seems to be a known bug.
My workaround is to use Google Sheets instead. Sheets “tries to help” in other annoying ways ;-) but it solves this particular issue.
Thanks, Walt