On the spreadsheet in question there is a column that contains plain numbers in a particular sequence. As an example:
Sometimes when typing in the next sequenced number it will automatically add commas, so the number comes out as
3,050,513. It also does this if I highlight a row of numbers above to use as a "guide" to add numbers automatically to rows below.
I have tried to set the column format as plain text and as no decimals to no avail. Any ideas?