Forum Discussion

yourisk's avatar
yourisk
Copper Contributor
Aug 29, 2022
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 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

 

  • yourisk 

    You can use the TEXT function:

     

    CONCATENATE(TEXT([@[Price per]]; "0,00"); " / 100 "; [@[content type]])

2 Replies

  • yourisk 

    You can use the TEXT function:

     

    CONCATENATE(TEXT([@[Price per]]; "0,00"); " / 100 "; [@[content type]])

    • yourisk's avatar
      yourisk
      Copper Contributor
      Works perfectly!
      Thanks so much for the quick and very complete answer! Mijn dank is groot!

Resources