Thread
:
Using the AND function with fractions
View Single Post
#
2
Roger Govier
Posts: n/a
Using the AND function with fractions
Hi
Try
="Result : "A1&TEXT(B1,"0/0")&" "&TEXT(C1,"00/00")
Regards
Roger Govier
wrote:
I have three data fields that I wish to concatenate. Two of these
fields are fractions. However, when I use the AND function to
concatenate them together the fractions are displayed as decimal
inches.
Here's what is happening now:
SR1001 5/8 13/16 Result: SR1001 0.625 0.8125
Here's what I need:
SR1001 5/8 13/16 Result: SR1001 5/8 13/16
Reply With Quote