View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Edwin Edwin is offline
external usenet poster
 
Posts: 21
Default format cell that contain text and fraction

when i format cell that contains text and fraction with fraction and sort
them ascending order the result is not the way i wanted .
ex chisel 1/2, chisel 1/4, chisel 1/8 which should be chisel 1/8, chisel
1/4 and chisel 1/2