Price with 2 decimals

[Ewout_van_Zonne]

I have a Price calculated of € 9.60 (setting 2 decimals). When I use the amount in Concatenate it shows:The price is € 9.6 less.
How do I get the zero back in? A calculation result of € 9.61 goes well.

[Suvrutt_Gurjar]

Could you please try

CONCATENATE("The price is “, TEXT([Price Column]), " less”)

[Ewout_van_Zonne]

Seems to work. Thanks!

[Aleksi · Accepted solution]

The reason is the TEXT() expression which follow your locale settings.

[Steve]

For reference:

help.appsheet.com

TEXT()

Format as text