When converting a Price column to Text using ...

(Bellave Jayaram) #1

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.

(Praveen Seshadri (AppSheet)) #2

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) #3

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