When converting a Price column to Text using CONCATENATE(), the formatting is not preserved ($1,300,543 becomes 1300543). Could we have a way to preserve the formatting, please?
Perhaps some function like - ASDISPLAYED([Price Col])
Thanks for considering.
Can you use TEXT() instead โ at least for things like Dates, this preserves the locale-aware formatting.
Iโm not sure we actually do preserve the currency formatting for prices though we should.
@praveen Yup, it works and does preserve the currency formatting.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |