+ Reply to Thread
Results 1 to 6 of 6

this tool for converting to fraction to decimal it is not running properly

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    this tool for converting to fraction to decimal it is not running properly

    please help me out its urgent i need this tool to convert fraction to decimal
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: this tool for converting to fraction to decimal it is not running properly

    @baig123

    You know you are on a forum members trying to help you (in there own free time).

    You feel the need to tell us it is urgent.

    Maybe it is urgent for you, but maybe not for us.

    You get better help if you appreciate the (spare) time members spend on this forum, helping other forummembers to learn excelskills.

    Having said that; i took a look at your file, but for me it is not clear, what you want to achieve.

    You don't add in which sheet the problem exist and don't add where you post your disered result.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: this tool for converting to fraction to decimal it is not running properly

    sorry for that

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: this tool for converting to fraction to decimal it is not running properly

    @baig123

    Sorry for what part of my reply?

  5. #5
    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: this tool for converting to fraction to decimal it is not running properly

    Hi,

    Assuming your Q. is about the note on the abbreviations sheet there are fraction values on the Abbreviations sheet where a leading zero is required.
    A28 for instance

    You can of course derive the decimal values with the formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and use the custom format
    "#.0000"

    to suppress leading zeros WHERE ALLOWABLE.
    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.

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: this tool for converting to fraction to decimal it is not running properly

    Tool_to_replace_Fraction_to_decimal_v1_MrShorty.xlsmI, too, am having some trouble understanding your purposes here.

    Is this something you need to do a lot? The main thing I notice is that your table in "Abbreviations" is all text strings. Excel is perfectly capable of handling fractions as actual numbers (at least, when it isn't trying to treat them as dates). If you format a cell (or group of cells) as fraction (with the desired number of digits), then you can simply enter the fractions and Excel will store them as numbers. Converting from fraction to decimal is as simple changing the formatting or using a formula like =A2 and formatting that cell as decimal. Depending on what you are doing, it may not even be necessary to convert to decimal. I would suggest that, if you need to do this sort of thing a lot, that you practice working with fractions as numbers rather than trying to work with numbers (whether fraction or decimal) as text.

    See illustration in attachment
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Converting decimal into a fraction via vba
    By pooky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2013, 08:32 PM
  2. [SOLVED] Fraction to Decimal
    By Michael D in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-13-2013, 03:21 PM
  3. [SOLVED] Unusual fraction to decimal
    By honkin in forum Excel General
    Replies: 10
    Last Post: 07-03-2012, 08:35 PM
  4. [SOLVED] leave the decimal fraction
    By Darrel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-06-2006, 02:00 AM
  5. [SOLVED] formula for converting decimal to inch & fraction
    By davepatrob in forum Excel General
    Replies: 1
    Last Post: 12-31-2005, 11:15 AM

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