Thread
:
converting decimals to fractions
View Single Post
#
2
Posted to microsoft.public.excel.misc
CLR
Posts: n/a
converting decimals to fractions
=A1&" "&TEXT(B1,"# #/#")
Vaya con Dios,
Chuck, CABGx3
"jason2444" wrote in message
...
A1 width
B1 5 1/4
C1 =a1&" "&b1
showing up as width 5.25
need to show up as width 5 1/4
thanks
Reply With Quote