| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL - Concatinated Y-axis Label | Excel Discussion (Misc queries) | |||
| formatted numbers displayed as ##### | New Users to Excel | |||
| Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
| VLookup with concatinated named range | Excel Worksheet Functions | |||
| Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
Linear Mode
