Remember Me?

#1
June 6th 18, 02:55 PM
 Junior Member First recorded activity by ExcelBanter: Jun 2018 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
June 6th 18, 05:03 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,607
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
June 6th 18, 05:16 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,607
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Michael Dugan Excel Worksheet Functions 2 February 13th 13 03:27 AM Alvin Excel Programming 2 April 18th 10 10:48 PM Megan Excel Worksheet Functions 0 October 15th 09 04:49 PM davepatrob Excel Discussion (Misc queries) 1 December 31st 05 03:10 PM antac Excel Worksheet Functions 1 February 28th 05 05:02 PM

All times are GMT +1. The time now is 12:03 AM.