Since column type impacts how AppSheet handles your data, selecting the appropriate column type is important. AppSheet may not have recognized your data as currency either because it doesn't yet recognize
Price in your language or because you used a spreadsheet column header such as
You can change your Column Type to
Price and since AppSheet displays currency in US Dollars, regardless of your selected Data locale, you can select the correct form of currency as well.
- Select Data > Columns and expand the table you would like to edit.
- Locate the column that you would like to edit and click the Edit (pencil) icon.
- Select Price from the Type drop-down, if it isn't already selected.
- Select your local currency symbol in the Currency symbol drop-down.
- Click Done.
- Save your changes.