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

Raga85

Editor

posted on 3 years ago — updated on 1 second ago

73
views

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

Open your project in Excel. If you're in Excel, you can go to File > Open or you can right-click the file in your file browser.

Select an empty cell where you want to display your decimal value. 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.

Enter the formula: =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).

Press ↵ Enter (Windows) or ⏎ Return (Mac). The cell you have selected and entered the formula in will display the decimal value only within the string.