Download Article
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
-
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.
Advertisement -
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)
. [1] X Research source
- If you want to keep the negative or positive signs with your decimals, use the formula
-
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. [2] X Research source
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
Thanks for submitting a tip for review!
References
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,623 times.
Advertisement