How to Extract a Decimal Value in Excel (in 4 Steps)

PDF download Download Article
PDF download Download Article

Do you have data entered into your Excel sheet and want to see only the decimals? This wikiHow will teach you how to extract a decimal value in Excel using a formula.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/60\/Extract-a-Decimal-Value-in-Excel-Step-1.jpg\/v4-460px-Extract-a-Decimal-Value-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/6\/60\/Extract-a-Decimal-Value-in-Excel-Step-1.jpg\/v4-728px-Extract-a-Decimal-Value-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    If you're in Excel, you can go to File > Open or you can right-click the file in your file browser.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ae\/Extract-a-Decimal-Value-in-Excel-Step-2.jpg\/v4-460px-Extract-a-Decimal-Value-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/a\/ae\/Extract-a-Decimal-Value-in-Excel-Step-2.jpg\/v4-728px-Extract-a-Decimal-Value-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This can be anywhere on your spreadsheet since the formula contains the cell you want to extract data from.
    • For example, you can select cell E7 even if all your data is located in cells A1-A20.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e0\/Extract-a-Decimal-Value-in-Excel-Step-3.jpg\/v4-460px-Extract-a-Decimal-Value-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/e\/e0\/Extract-a-Decimal-Value-in-Excel-Step-3.jpg\/v4-728px-Extract-a-Decimal-Value-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    =ABS(A1-TRUNC(A1)) . A1 represents the cell the data is located within, so you'll want to change that if your data isn't in cell A1.
    • If you want to keep the negative or positive signs with your decimals, use the formula =A1-TRUNC(A1) . [1]
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/22\/Extract-a-Decimal-Value-in-Excel-Step-4.jpg\/v4-460px-Extract-a-Decimal-Value-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/2\/22\/Extract-a-Decimal-Value-in-Excel-Step-4.jpg\/v4-728px-Extract-a-Decimal-Value-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The cell you have selected and entered the formula in will display the decimal value only within the string. [2]
    5. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Link Sheets in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      How to Combine Columns in Excel Without Losing Data
      Advertisement

      References

      1. ↑ https://www.extendoffice.com/documents/excel/1653-excel-extract-decimal-value.html
      2. ↑ https://www.teachexcel.com/excel-tutorial/get-the-decimal-part-of-a-number-in-excel_1586.html

      About This Article

      Article Summary X

      1. Open your project in Excel.
      2. Select an empty cell where you want to display your decimal value.
      3. Enter "=ABS(A1-TRUNC(A1))" .
      4. Press Enter (Windows) or Return (Mac).

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 16,597 times.

      Is this article up to date?

      Advertisement