I am pasting a list of IP addresses into a spreadsheet, for example:
87.122.122.222
and I seem I cannot prevent for Libreoffice Calc to make 87122122222 out of it. This only happens for some addresses, others are not being changed: 93.205.5.123
Any suggestions?
I tried Format -> Cell and set it to Text format but that doesn’t change anything.
I tried prepending spaces to force it look like text, but Libreoffice removes those as well.