View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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