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 ...
- Aug 29, 2022
You can use the TEXT function:
CONCATENATE(TEXT([@[Price per]]; "0,00"); " / 100 "; [@[content type]])
HansVogelaar
Aug 29, 2022MVP
You can use the TEXT function:
CONCATENATE(TEXT([@[Price per]]; "0,00"); " / 100 "; [@[content type]])
yourisk
Aug 29, 2022Copper Contributor
Works perfectly!
Thanks so much for the quick and very complete answer! Mijn dank is groot!
Thanks so much for the quick and very complete answer! Mijn dank is groot!