Numeric Values from form unexpectedly converting to currency
Hi, I have had a sheet with form I've been using for a few years now. Just in the last month, a couple of the columns have been displaying data incorrectly. I have customer numbers that can contain a prefix of $. These are now converting to currency format. So customer $3131231 is showing up as $3,131,231. I also have product model numbers changing to weird values. For example, 204 now shows as 20400.0
How can I have it restrict the values to exactly what is entered? these columns are set to text/number. If I change the customer column to NO Currency, it keeps the commas and removes the dollar sign, which is still very wrong. And for my product number, I don't even know why products with no alpha characters are converting to thousands with a decimal to one place.