I've been using Google Sheets to create a record of car parts, entering:
- each part's serial number,
- the quantity of that particular part,
- the name of the part and
- the location where I'm storing the part.
I have entered over 800 different parts now with multiple numbers for each but looking back I have noticed that some of the amount numbers seem to have 'decimalised' at the start of the sheet. I have only been using whole numbers and the formatting on all the cells is set to plain text. I can redo the 70 or so that have corrupted but I'm worried that it could happen again.
Can anyone explain how I might prevent this happening?