How do I have excel convert fractions to decimals?
Hi
If the cell is formatted as fraction, just FormatCellsGeneral
or if you want to retain both, assuming the fraction is in A1 then in
another cell =A1 and format that cell as General.
If the fraction has been entered as text in a cell then
=LEFT(A1,FIND("/",A1)-1)/MID(A1,FIND("/",A1)+1,255)
--
Regards
Roger Govier
"pgail" wrote in message
...
I am trying to convert fractions to decimals
|