# Removing Decimal Places in CONCATENATE() Function

#1

Hi all,

I’m using the following `CONCATENATE()` function inside of a `SWITCH()` which is displaying the result below. Is there a way to remove the decimal places so that it’s only correct to two?

CONCATENATE("4 tins: ",“£”,6*26.32)
=
4 tins: £157.92000000000002

#2

My first thought is this: is the calculation “6*26.32” based on a field in your table? If so, than it would be a lot easier to refer to that field in the CONCATENATE formula.

Regards,
André

#3

Thanks for the replay @Andre_Zijlstra.

No, the figure on the right of the multiplication is a lookup field from another table. I’ve changed it here for clarity.

#4

Thank you @tom_pandsmarine.

So, to make sure I understand it the right way: In the formula you refer to a field, and then it renders a figure you showed in the first post?

#5

That’s right @Andre_Zijlstra.

I’ve just found a workaround by using the `ROUND()` funtion:

CONCATENATE("4 tins: ",“£”, ROUND(6*26.32,2,0))
=
4 tins: £157.92

It going to end up being a messy formula but it works