View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin Vaughn
 
Posts: n/a
Default converting decimals to fractions

This worked for me when I tried it:

=F61& " " & TEXT(G61, "# ?/4")
--
Kevin Vaughn


"jason2444" wrote:

A1 width
B1 5 1/4
C1 =a1&" "&b1
showing up as width 5.25
need to show up as width 5 1/4

I have tried formating the cells dosen't work