Thousands separator not working in Price Type Column?
I set a column as Price.
Then I set the currency to R$ and Thousands Separator to True.
However, when inserting data in the form, the thousands separator “.” does not appear, neither when typeing the number, nor when changing between fields and not even when saving the sheet and going to Google Sheets.
Also, the decimal (cents) usually is shown as ,00 even if no cents were included.
I guess this is important as currency is usually right justified, and if some numbers have cents on them and others do not, the position of the number’s won´t match, and that makes it more difficult to make an analysis such as mentally adding values.
LinkedIn
Twitter
