How to prevent OpenOffice/LibreOffice Calc from changing what you input (data, numbers,…)
If you want your input to be interpreted as text and preventing Calc to do fancy (and annoying) things with your input, you have to change the format before entering any value. Select the cells/columns/rows. Right-click ‘Format Cells…’ Select the tab ‘Numbers’ In the list ‘Category’, select ‘Text’ (the last option) Select the format ‘@’ … Read more