I'm trying to to a number's formatting withing a concatinated cell that
contains both numbers and text from other cells. This is the formula that
I'm currently using with it's result.

="Procurement of "&'Pricing Sheet'!B10&" timbers totaling approximately
"&'Pricing Sheet'!E52&" board feet of "&'Pricing Sheet'!B6

What's being shown:
"Procurement of 100 timbers totaling approximately 5555.55555555555556 board
feet of Southern Yellow Pine"

What's desired:
"Procurement of 100 timbers totaling approximately 5,555 board feet of
Southern Yellow Pine"


Please Help!! It would make my life a lot easier!!!!