Forum Discussion
yourisk
Aug 29, 2022Copper Contributor
How to limit amount of digits when combining content of 2 cells
Hello all,
I am merging the content of two cells in another cell with some additional text for use on pricecards. But now the number value from the first cell ([price per]) shows a lot of digits. I just want 2 digits after the point/comma.
How can I have this done?
The used formula for joining the values is: =CONCATENATE([@[Price per]]; " / 100 "; [@[content type]])
I know there are other ways but these have the same result.
thank you very much
Kind regards,
Joris
You can use the TEXT function:
CONCATENATE(TEXT([@[Price per]]; "0,00"); " / 100 "; [@[content type]])
2 Replies
Sort By