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?
|