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

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