View Single Post
  #6   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?

Sorry, I missed out the leading integers.

=LEFT(A1,FIND(" ",A1)-1) &"."& MID(A1,FIND(" ",A1)+1,find("/",A1),1)
/MID(A1,FIND("/",A1)+1,255)
&" x " &
LEFT(B1,FIND(" ",B1)-1) &"."&MID(B1,FIND(" ",B1)+1,find("/",B1),1)
/MID(B1,FIND("/",B1)+1,255)


--
Regards

Roger Govier


"pgail" wrote in message
...
I am typing in measuments of packages - i.e. 16 3/8 X 5 1/8, I want
excel to
convert to decimal. I have tried format cells, and convert, neither
have
this option available.

"Ron Coderre" wrote:

Can you give examples of how you need to deal with the fractions?
Are you typing them?
Are they in data that was imported?
Are you referring to them in another cell?

What have you tried?
What were you hoping for?
What were the actual results?

***********
Regards,
Ron

XL2002, WinXP


"pgail" wrote:

I am trying to convert fractions to decimals