FORMATTING COMBINED CELLS PARTS AS FRACTIONS

  • Thread starter Thread starter Steve A
  • Start date Start date
S

Steve A

h17=36 1/2
k17=48 3/4

A17=E17& " - " &H17& " "&J17&" " &K17& " "&Q17

1 - 36.5 x 48.75 3/16" CLEAR TEMP

HOW CAN IGET A17 TO DISPLAY THE VALUES OF H17 & K17 AS
FRACTION IN A17 instead of a decimal?
 
Hi:

A17=E17&" - "&TEXT(H17,"# ?/?")&" "&J17&" " &TEXT(K17,"# ?/?")&"
"&Q17

Regards,

Vasant.
 
Steve,

Try

=E17& " - " &=TEXT(H17,"# ?/???????")& " "&J17&" " &=TEXT(K17,"#
?/???????")& " "&Q17


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top