| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number formating in CONCATENATE formula (Part 2)
Could anyone tell me how do this.
Two cells (B3) which reads 175.50 (E3) which reads 6 15/16. (This one is the result of a formula and has been formated to read as a fraction) I would like the result of my CONCATENATE to read: 175.50mm [6 15/16"] but can't get the fraction to work. This is what I have in my formula at the moment: =CONCATENATE(FIXED(B3,1,TRUE), "mm [", FIXED(E3,2,TRUE)," in]") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number formating in CONCATENATE formula (Part 2)
=TEXT(B3,"0.00")&"mm ["&TEXT(E3,"0 00/00")&"""]"
"V Padale" wrote: Could anyone tell me how do this. Two cells (B3) which reads 175.50 (E3) which reads 6 15/16. (This one is the result of a formula and has been formated to read as a fraction) I would like the result of my CONCATENATE to read: 175.50mm [6 15/16"] but can't get the fraction to work. This is what I have in my formula at the moment: =CONCATENATE(FIXED(B3,1,TRUE), "mm [", FIXED(E3,2,TRUE)," in]") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number formating in CONCATENATE formula (Part 2)
Many thanks, that works beautifully! Unfortunately, it leads me to another
question though. I am working with Imperial measurements and so would prefer forcing my fractions into the units found on a tape measure. Is there an easy way to do that, or am I wishful thinking? "Teethless mama" wrote: =TEXT(B3,"0.00")&"mm ["&TEXT(E3,"0 00/00")&"""]" "V Padale" wrote: Could anyone tell me how do this. Two cells (B3) which reads 175.50 (E3) which reads 6 15/16. (This one is the result of a formula and has been formated to read as a fraction) I would like the result of my CONCATENATE to read: 175.50mm [6 15/16"] but can't get the fraction to work. This is what I have in my formula at the moment: =CONCATENATE(FIXED(B3,1,TRUE), "mm [", FIXED(E3,2,TRUE)," in]") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number formating in CONCATENATE formula (Part 2)
On Apr 16, 8:57 am, V Padale
wrote: Many thanks, that works beautifully! Unfortunately, it leads me to another question though. I am working with Imperial measurements and so would prefer forcing my fractions into the units found on a tape measure. Is there an easy way to do that, or am I wishful thinking? "Teethless mama" wrote: =TEXT(B3,"0.00")&"mm ["&TEXT(E3,"0 00/00")&"""]" "V Padale" wrote: Could anyone tell me how do this. Two cells (B3) which reads 175.50 (E3) which reads 6 15/16. (This one is the result of a formula and has been formated to read as a fraction) I would like the result of my CONCATENATE to read: 175.50mm [6 15/16"] but can't get the fraction to work. This is what I have in my formula at the moment: =CONCATENATE(FIXED(B3,1,TRUE), "mm [", FIXED(E3,2,TRUE)," in]") What's it doing? Try "# ??/16" in the code instead of "0 00/00". |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number formating in CONCATENATE formula (Part 2)
Bravo, that was Excellent! (Pun intended) :o) Now if I can just figure out
how to simplify the fraction! "Spiky" wrote: What's it doing? Try "# ??/16" in the code instead of "0 00/00". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with formating % in concatenate formula | Excel Discussion (Misc queries) | |||
| number formats after concatenate | Excel Worksheet Functions | |||
| superscript in part of a string when using concatenate | Excel Discussion (Misc queries) | |||
| How to Concatenate with a text & number | Excel Worksheet Functions | |||
| Copy cell formating as part of a formula | Excel Worksheet Functions | |||
Linear Mode
