View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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