Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Using the AND function with fractions

0 views
Skip to first unread message

twl...@ontuet.com

unread,
Oct 18, 2005, 10:09:35 AM10/18/05
to
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

Roger Govier

unread,
Oct 18, 2005, 10:24:10 AM10/18/05
to twl...@ontuet.com
Hi

Try
="Result : "A1&TEXT(B1,"0/0")&" "&TEXT(C1,"00/00")


Regards

Roger Govier

0 new messages