How do I keep numbers formatted within a concatinated cell?
 

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

How do I keep numbers formatted within a concatinated cell?
 

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

How do I keep numbers formatted within a concatinated cell?
 

I believe you need to use

&TEXT(TRUNC('Pricing Sheet'!E52),"#,#")&etc


--


Regards,


Peo Sjoblom


"akphidelt" wrote in message
...
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!!!!

How do I keep numbers formatted within a concatinated cell?
 

One more question that I should've asked....

Can I insert a ROUND(value,-1) function within the formula???



"Peo Sjoblom" wrote:

I believe you need to use

&TEXT(TRUNC('Pricing Sheet'!E52),"#,#")&etc


--


Regards,


Peo Sjoblom


"akphidelt" wrote in message
...
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!!!!