+ Reply to Thread
Results 1 to 2 of 2

Converting decimal into a fraction via vba

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    35.0456° N, 85.3097° W
    MS-Off Ver
    2010
    Posts
    35

    Converting decimal into a fraction via vba

    Conversion.jpg
    When I recorded a macro just to convert a decimal into a fraction it displayed the code as:
    Please Login or Register  to view this content.
    -----> How can I embed this code into the formula shown in formula box in the attach pic.
    The cell with the arrow underneath was converted manually--no code.
    Is what I want to do even possible?
    Thanks to all for the help.

    Code tags added
    Last edited by FDibbins; 10-28-2013 at 08:29 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Converting decimal into a fraction via vba

    Hi and welcome to the forum

    Please use code tags when posting VBA code, and also please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

    Having said that, you dont need VBA for this, you can just use the built-in fraction formatting

    If you want to show the ' (feet), then use custom formatting...0' #/##
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Convert fraction to a decimal
    By Dillons Grandpa in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-24-2013, 12:49 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

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