When importing a CSV file with currencies, what must the formatted column be set to?

When importing a CSV file containing currencies, it is essential to set the formatted column to Number. This is because the numerical representation of currencies allows for proper calculation and analysis within the system. By designating the currency values as numbers, they can be used effectively for mathematical operations, such as addition or subtraction, which is crucial in scenarios involving financial data.

Setting the column to Text would treat the currency values as strings, making it impossible to perform arithmetic operations, while selecting Date or Boolean would be inappropriate since these formats do not apply to currency values. Consequently, designating the formatted column as Number ensures that the data is correctly interpreted and managed as financial information, allowing for accurate reporting and processing of currency-related calculations.