SOLVED

Format question

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

Jon

2 Replies
best response confirmed by Jon_Morgan1958 (New Contributor)
Solution

@Jon_Morgan1958 

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

 

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

Many thanks, sorted now.

 

@Jon_Morgan1958