View Single Post
  #3   Report Post  
Dave O
 
Posts: n/a
Default

I clicked Edit Replace, entered "Search For" ( then "Replace With" /.
Excel automatically converted the fraction to least common
denominator. Then I formatted the cell as numeric with 7 decimal
places and got your intended result. Does that work the same for you?