SOLVED

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

Copper 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

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

# Re: How to limit amount of digits when combining content of 2 cells

You can use the TEXT function:

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

# Re: How to limit amount of digits when combining content of 2 cells

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

# Re: How to limit amount of digits when combining content of 2 cells

You can use the TEXT function:

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