When converting a Price column to Text using ...

AppSheet AppSheet Q&A
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.

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.

1 Like
3

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

1 Like