Format question

[Jon_Morgan1958]

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

[#2 · Accepted solution]

@Jon_Morgan1958 

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

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

[#3]

Many thanks, sorted now.

@Jon_Morgan1958