+ Reply to Thread
Results 1 to 14 of 14

How do I turn a fraction into a decimal?

Hybrid View

  1. 02-04-2013, 12:38 PM #1
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How do I turn a fraction into a decimal?

    Quote Originally Posted by ad9051 View Post
    Solved thanks guys, including RB. I'm using RB's solution.

    Cheers

    Alan
    Interesting how different minds work!
    Personally I prefer DDL's offering which is shorter, but arguably less obvious. I'm always intrigued by 'off the wall' solutions where Excel is used in ways I'm sure the designers never anticiapted.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  2. 02-04-2013, 12:55 PM #2
    ad9051
    ad9051 is offline
    Forum Contributor
    Join Date
    12-01-2010
    Location
    Southampton, England
    MS-Off Ver
    Excel 2007
    Posts
    303

    Re: How do I turn a fraction into a decimal?

    I did try both solutions and I couldn't get DDLs to work, since I will have a macro converting the range to values it doesn't matter which is the faster/more efficient.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1