Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting Fraction that is in text form into decimal
Import data with fractions like this 44"1/16 so it reads it as text and not number. I need a formula to turn it into decimal numbers so I can use them in equations.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Fraction that is in text form into decimal
Hi,
Am Wed, 6 Jun 2018 14:55:30 +0100 schrieb Pack: Import data with fractions like this 44"1/16 so it reads it as text and not number. I need a formula to turn it into decimal numbers so I can use them in equations. try: =LEFT(A1,FIND("""",A1)-1)+MID(A1,FIND("""",A1)+1,FIND("/",A1)-FIND("""",A1)-1)/MID(A1,FIND("/",A1)+1,2) Regards Claus B. -- Windows10 Office 2016 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Fraction that is in text form into decimal
Hi,
Am Wed, 6 Jun 2018 18:03:17 +0200 schrieb Claus Busch: =LEFT(A1,FIND("""",A1)-1)+MID(A1,FIND("""",A1)+1,FIND("/",A1)-FIND("""",A1)-1)/MID(A1,FIND("/",A1)+1,2) you can also try it with an UDF. Copy the code into a standard module: Function Deci(myRng As Range) As Double Dim varData As Variant Dim varTmp As Variant varData = Split(myRng, """") varTmp = Split(varData(1), "/") Deci = varData(0) + varTmp(0) / varTmp(1) End Function and call the function on the sheet with e.g. =Deci(A1) Regards Claus B. -- Windows10 Office 2016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fraction to Decimal | Excel Worksheet Functions | |||
Fraction to decimal | Excel Programming | |||
How can I turn a fraction into a decimal. | Excel Worksheet Functions | |||
formula for converting decimal to inch & fraction | Excel Discussion (Misc queries) | |||
How do I change a text fraction. eg 1 1/2 into a decimal number, . | Excel Worksheet Functions |