You don't even need to do that. Just stick a single ' before any number/date and it will be treated as text. The problems are when importing/exporting though.

You don't even need to do that. Just stick a single ' before any number/date and it will be treated as text. The problems are when importing/exporting though. Even quoted numbers will lose the quote when exported to say, CSV. You need to explicitly save as quoted, and import quoted fields as text. The real issue is that these settings are not the default. In LibreOffice (Save/Open CSV): https://imgur.com/a/ved7wgA https://imgur.com/a/ved7wgA