View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dig Dig is offline
external usenet poster
 
Posts: 17
Default Convert fraction to decimal

Is there anyway in Excel to format a cell so if the user types 61/4 it will
convert to 6.25? If not what is the best way to create a conversion so the
user can type in 51/2 and have 5.5 show up, either in another cell or in the
same cell?

Thanks for the help