Number formating in CONCATENATE formula (Part 2)

V

V Padale

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

V Padale

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 said:
=TEXT(B3,"0.00")&"mm ["&TEXT(E3,"0 00/00")&"""]"

V Padale said:
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]")
Click to expand...
Click to expand...
 
S

Spiky

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 said:
=TEXT(B3,"0.00")&"mm ["&TEXT(E3,"0 00/00")&"""]"
Click to expand...
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]")
Click to expand...
Click to expand...
Click to expand...

What's it doing? Try "# ??/16" in the code instead of "0 00/00".
 
V

V Padale

Bravo, that was Excellent! (Pun intended) :blush:) Now if I can just figure out
how to simplify the fraction!

:

What's it doing? Try "# ??/16" in the code instead of "0 00/00".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

to CONCATENATE from the smallest date with at least 2 criteria 17
Formatting a Cell Reference with a Formula 6
CONCATENATE Cells Formated as fractions 4
help with format change of date part of concatenate formula 1
Format part of text in concatenated field 4
Finding dates without attention to data formats 1
Number Formatting in a concatenated cell 3
Erratic display of concatenation 3

Top