View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Change 1/2 to .5

Highlight the cell in question, right click, select Format Cells and
change the format from Fraction to Number with the appropriate number
of decimal places.