Fractions

sandramac
sandramac used Ask the Experts™
on
Hello,

I have a formula  =Sheet1!E6&"SM" on sheet2 however I need it in a fraction format.  Current data on sheet 1E6 is 1 1/2, but the formula is returning 1.5SM, I need it to display 1 1/2SM
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
This explains how.
Software Professional
Commented:
Try this:
=TEXT(Sheet1!E6,"# #/# ") & "SM"

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial