Forum Discussion
Solved
Format question
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 decima...
Let's say you want to display 2 decimal places:
=TEXT(AvgTrans,"0.00")&" Transactions per Week"
Let's say you want to display 2 decimal places:
=TEXT(AvgTrans,"0.00")&" Transactions per Week"