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]")

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]")

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]")

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".

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".