View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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