Inches to Fractions

bschwartz

Well-known Member
Joined
Jan 5, 2013
Messages
1,367
Hello,

How would I turn these inch values into decimals (they are originally fractions entered as text):

C8 = 5/8"
C9 = 3/4"

Thanks!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
4,037
Office Version
  1. 365
Platform
  1. Windows
<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">5/8"</td><td style="text-align: right;;">0.625</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">3/4"</td><td style="text-align: right;;">0.75</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">3/5"</td><td style="text-align: right;;">0.6</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet3</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B1</th><td style="text-align:left">=1*LEFT(<font color="Blue">A1,FIND(<font color="Red">"/",A1</font>)-1</font>)/MID(<font color="Blue">A1,FIND(<font color="Red">"/",A1</font>)+1,LEN(<font color="Red">A1</font>)-FIND(<font color="Red">"/",A1</font>)-1</font>)</td></tr></tbody></table></td></tr></table><br />
 

bschwartz

Well-known Member
Joined
Jan 5, 2013
Messages
1,367
That works great for the fractions. Thanks! Unfortunately, I failed to mention another possible value which is a whole number of inches. For instance 1" or 12". Can that be worked into your formula?
 

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
4,037
Office Version
  1. 365
Platform
  1. Windows
Maybe not the most elegant way but here:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">5/8"</td><td style="text-align: right;;">0.625</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">3/4"</td><td style="text-align: right;;">0.75</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">3/5"</td><td style="text-align: right;;">0.6</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">1"</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">2.5"</td><td style="text-align: right;;">2.5</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">3/8"</td><td style="text-align: right;;">0.375</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">2/5"</td><td style="text-align: right;;">0.4</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet3</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B1</th><td style="text-align:left">=IFERROR(<font color="Blue">1*LEFT(<font color="Red">A1,FIND(<font color="Green">"/",A1</font>)-1</font>)/MID(<font color="Red">A1,FIND(<font color="Green">"/",A1</font>)+1,LEN(<font color="Green">A1</font>)-FIND(<font color="Green">"/",A1</font>)-1</font>),1*SUBSTITUTE(<font color="Red">A1,"""",""</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
 

Watch MrExcel Video

Forum statistics

Threads
1,108,991
Messages
5,526,098
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top