Format question

Occasional Contributor


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.


2 Replies
best response confirmed by Jon_Morgan1958 (Occasional Contributor)


Let's say you want to display 2 decimal places:


=TEXT(AvgTrans,"0.00")&" Transactions per Week"

Many thanks, sorted now.