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