Aug 29 2022 09:21 AM
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
Aug 29 2022 09:29 AM
SolutionYou can use the TEXT function:
CONCATENATE(TEXT([@[Price per]]; "0,00"); " / 100 "; [@[content type]])
Aug 29 2022 09:56 AM
Aug 29 2022 09:29 AM
SolutionYou can use the TEXT function:
CONCATENATE(TEXT([@[Price per]]; "0,00"); " / 100 "; [@[content type]])