Numeric Values from form unexpectedly converting to currency

Terri Mason

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.

Thanks.

Mathieu PERSICO

Hi Terri,

To correct this, you should play with the comma and percentage buttons in the toolbar at the top of your sheet.

Have a good day,

Paul Newcome

You could also include "help text" in the form to instruct users to enter an apostrophe before entering the customer or product number. The apostrophe will not be visible on the sheet but will convert everything in that specific cell into a text string will will show exactly how it is entered without attempting to convert it to a number or dollar amount.