SOLVED

How to limit amount of digits when combining content of 2 cells

Copper Contributor

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

 

excel.jpg

2 Replies
best response confirmed by yourisk (Copper Contributor)
Solution

@yourisk 

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!
1 best response

Accepted Solutions
best response confirmed by yourisk (Copper Contributor)
Solution

@yourisk 

You can use the TEXT function:

 

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

View solution in original post