Hi. Bit of help please, simple answer I’m sure but it eludes me. My formula is, =AvgTrans&" Transactions per Week".How please do I format the result of “AvgTrans” to limit the amount of decimal places displayed?Many thanks.Jon

Jon_Morgan1958 Let's say you want to display 2 decimal places: =TEXT(AvgTrans,"0.00")&" Transactions per Week"

Forum Discussion

Copper Contributor

Mar 29, 2021

Solved

Hi. Bit of help please, simple answer I’m sure but it eludes me. My formula is, =AvgTrans&" Transactions per Week".

How please do I format the result of “AvgTrans” to limit the amount of decimal places displayed?

Many thanks.

Jon