This article was co-authored by Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for wikiHow. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 1,278 times.
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
-
1Open 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.
-
2Select 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.
Advertisement -
3Enter 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).[1]
- If you want to keep the negative or positive signs with your decimals, use the formula
-
4Press ↵ Enter (Windows) or ⏎ Return (Mac). The cell you have selected and entered the formula in will display the decimal value only within the string.[2]Advertisement
References
About This Article
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).
