Results 1 to 6 of 6

Text Fraction to formula MK2

Threaded View

  1. #1
    Registered User
    Join Date
    08-20-2018
    Location
    Mass, USA
    MS-Off Ver
    MS365 version 2303
    Posts
    28

    Unhappy Text Fraction to formula MK2

    I have a spreadsheet with text based fraction values. I would like to convert these fractions into decimals in an adjacent column. I asked a similar question the other day, but I'm still having issues.
    Basically, I am wondering if there is an easy way to convert 1/8 in B2 to =1/8 in B3.

    The first rows of my text column looks like this.

    2
    1-1/4
    1/8
    9/32

    where 1-1/4 represents 1+(1/4)

    As you can see, there are a few different styles of values. Any ideas?
    Last edited by Ian.Lance; 08-30-2018 at 02:29 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Add Text prior to fraction
    By colarguns in forum Excel General
    Replies: 16
    Last Post: 07-14-2018, 06:14 AM
  2. Refinancing one fraction selling the other fraction in a context of variable price
    By General Patton in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-18-2017, 07:55 AM
  3. Replies: 3
    Last Post: 09-04-2013, 01:56 AM
  4. Replies: 10
    Last Post: 06-11-2013, 06:11 PM
  5. Import fraction from text file
    By Rock_boy in forum Excel General
    Replies: 2
    Last Post: 03-26-2012, 05:05 PM
  6. Replies: 7
    Last Post: 12-17-2010, 04:23 PM
  7. convert fraction to text
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2009, 03:23 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1