Just off the top of my head try this...


="Procurement of "&'Pricing Sheet'!B10&" timbers totaling approximately
"&Text('Pricing Sheet'!E52&,"#,#")&" board feet of "&'Pricing Sheet'!B6

If thats not right just try playing around with the Text function

So Text(Cell,"#,#") Would format a cell to what you want.

"IsaacEXP" wrote:

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!!!!