Price with 2 decimals

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.

Could you please try

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

2 Likes

Seems to work. Thanks!

1 Like

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

3 Likes

For reference:

1 Like