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.
Solved! Go to Solution.
The reason is the TEXT() expression which follow your locale settings.
Could you please try
CONCATENATE("The price is โ, TEXT([Price Column]), " lessโ)
Seems to work. Thanks!
The reason is the TEXT() expression which follow your locale settings.
For reference:
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |