About 50 results
Open links in new tab
  1. Convert fraction to decimal [SOLVED] - Excel Help Forum

    Dec 9, 2019 · Re: Convert fraction to decimal AlKey, Can you adjust this formula to show three decimal places? I have tried changing it by formatting cells but it doesn't seem to work.

  2. Convert Fraction (Text Value) to Decimal (Numeric Value)? [SOLVED]

    Nov 15, 2023 · Convert Fraction (Text Value) to Decimal (Numeric Value)? This should (I'd think) be simple, but I can't figure it out. I have Width (a text variable) that can contain a fraction …

  3. [SOLVED] Converting text based fractions to numerical values

    Aug 28, 2018 · Converting text based fractions to numerical values I have a spreadsheet with text based fraction values. I would like to convert these fractions into decimals in an adjacent …

  4. Convert inch fractions to decimal, improve formula [SOLVED]

    Oct 26, 2023 · Re: Convert inch fractions to decimal, improve formula I don't have a better way to convert from fractional format in text to decimal numeric format without writing it in VBA. But …

  5. Convert Feet and Inches (Fractions) to Decimal Feet

    Jun 29, 2022 · Re: Convert Feet and Inches (Fractions) to Decimal Feet Try wrapping the entire formula in a =ABS Function.

  6. decimal to fraction - Excel Help Forum

    Apr 6, 2015 · Convert fraction to a decimal By Dillons Grandpa in forum Excel Formulas & Functions Replies: 14 Last Post: 02-24-2013, 12:49 PM

  7. Convert decimal to 1/16ths [SOLVED] - Excel Help Forum

    Jan 22, 2014 · Convert decimal to 1/16ths I am doing a drawing and when I divide the measurement say 10/ 3, I get a decimal of 3.33. I need to convert that to the nearest 1/16 of …

  8. Converting decimal into a fraction via vba - Excel Help Forum

    Oct 28, 2013 · 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:

  9. Converting Decimal to Fraction Text VBA - Excel Help Forum

    Jul 27, 2014 · Converting Decimal to Fraction Text VBA Hi Guys, Is there any easy way to convert a decimal to a text fraction in vba. In excel itself you can use e.g. =text (B5,"0/00"), however …

  10. convert fractions to decimals and decimal to fraction

    Dec 19, 2014 · Re: convert fractions to decimals and decimal to fraction Just format the number as a fraction: Format > Cells > Number tab, choose Fraction in the Category box.