8 Aug
2020
8 Aug
'20
2:40 p.m.
On Fri, 7 Aug 2020 13:39:34 +1200, Peter Reutemann wrote:
I always thought that the explicit import dialog for CSV files in LibreOffice was far superior to Excel's "let's just try loading the CSV file and then the user can fix things that I screwed up"...
This comment <https://forums.theregister.com/forum/all/2020/08/07/army_promotion_excel_snafu/#c_4085999> mentions something called RIKEN identifiers, which can look like numbers. LO Calc does automatically format them as numbers in exponential format with its “Standard” column type, but changing that to “Text” fixes it.