Normalize Currency and Prices
6
votes
When creating the new field format, a currency field should be added. At present, a currency field has to be selected as single line text and Google sheets then has to have the relevent cells changed to currency. Currently, If a number format is selected, the value in Google sheets comes out wrong eg $43.50 becomes 4350.