When converting a Price column to Text using ...

[Bellave_Jayaram]

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.

[pravse]

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.

[Bellave_Jayaram]

@praveen Yup, it works and does preserve the currency formatting.