Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using the AND function with fractions
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 |
#2
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|