Home 
Search 
Today's Posts 
#1




How do I have excel convert fractions to decimals?
I am trying to convert fractions to decimals

#2




How do I have excel convert fractions to decimals?
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 
#3




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 
#4




How do I have excel convert fractions to decimals?
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 
#5




How do I have excel convert fractions to decimals?
Having seen your example, I would modify your entry so that you put the
first measurement in A1 and the second in B1 then modify my original posting to =MID(A1,FIND(" ",A1)+1,find("/",A1),1)/MID(A1,FIND("/",A1)+1,255) &" x " & 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 
#6




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




How do I have excel convert fractions to decimals?
Perhaps one of these:
Using A1: 16 3/8 X 5 1/8 Translated to decimal: B1: =(TRIM(LEFT(A1,SEARCH("X",A1)1)))&" X "&(TRIM(MID(A1,SEARCH("X",A1)+1,255))) returns 16.375 X 5.125 Or... B1: =TRIM(LEFT(A1,SEARCH("X",A1)1)) returns 16.375 B2: =TRIM(MID(A1,SEARCH("X",A1)+1,255)) returns 5.125 Is that something you can work with? *********** Regards, Ron XL2002, WinXP "pgail" wrote: 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 
#8




How do I have excel convert fractions to decimals?
Roger and Ron,
I learn a couple of things. Thanks. I was hoping that Text to Column could do some magic. But no luck. The best it can do is to split 16 3/8 X 5 1/8 in A1 into A1: 16 3/8 B1: 5 1/8 After formatting to general A1: 16.375 B1: 5.125 C1: =A1&" X "&B1 returns 16.375 X 5.125 You know I had this "crazy" idea that there might be some hidden features in Text to Column that would convert 16 3/8 X 5 1/8 to 16.375 X 5.125 in one shot. I guess no other features will do this either. I am over imaginative. By the way, I really like the fact that the double unary coerces the fraction to decimal. Thanks for listening. Epinn "Roger Govier" wrote in message ... 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 
#9




How do I have excel convert fractions to decimals?
Text to Column only works when there is an integer to the left of the fraction, e.g. 11 1/4.
If it is a fraction on its own, say 1/4, Text to Column will treat it as a date. Wonder if there is a way to get around this. Epinn "Epinn" wrote in message ... Roger and Ron, I learn a couple of things. Thanks. I was hoping that Text to Column could do some magic. But no luck. The best it can do is to split 16 3/8 X 5 1/8 in A1 into A1: 16 3/8 B1: 5 1/8 After formatting to general A1: 16.375 B1: 5.125 C1: =A1&" X "&B1 returns 16.375 X 5.125 You know I had this "crazy" idea that there might be some hidden features in Text to Column that would convert 16 3/8 X 5 1/8 to 16.375 X 5.125 in one shot. I guess no other features will do this either. I am over imaginative. By the way, I really like the fact that the double unary coerces the fraction to decimal. Thanks for listening. Epinn "Roger Govier" wrote in message ... 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 
#10




How do I have excel convert fractions to decimals?
Here's another option
With A1: 16 3/8 X 5 1/8 Then 1)Format cellls A1 and B1 as Category: Number 2)<data<texttocolumns Delimited Check: Other and use: X Click the [finish] button A1 becomes 16.375 B1: becomes 5.125 (the type coercions are automatic when the number format is NOT General) *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: Perhaps one of these: Using A1: 16 3/8 X 5 1/8 Translated to decimal: B1: =(TRIM(LEFT(A1,SEARCH("X",A1)1)))&" X "&(TRIM(MID(A1,SEARCH("X",A1)+1,255))) returns 16.375 X 5.125 Or... B1: =TRIM(LEFT(A1,SEARCH("X",A1)1)) returns 16.375 B2: =TRIM(MID(A1,SEARCH("X",A1)+1,255)) returns 5.125 Is that something you can work with? *********** Regards, Ron XL2002, WinXP "pgail" wrote: 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 
Reply 

Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Convert CSV File Into Formatted Excel Document  Excel Discussion (Misc queries)  
WordPad file convert in Excel  Excel Discussion (Misc queries)  
How can I convert an Excel file to an Adobe .pdf file by using Ex.  Excel Discussion (Misc queries)  
how to convert GETPIVOTDATA from excel 2000 to excel 2002...  Excel Worksheet Functions  
How do I convert decimal inches to fractions in excel  Excel Discussion (Misc queries) 