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