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.920000...