Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. 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 16,015 times.
Learn more...
Do you have data entered into your Excel sheet and want to see only the decimals? This How.com.vn will teach you how to extract a decimal value in Excel using a formula.
Steps
Download Article
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]
- 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]
Expert Q&A
Tips
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).
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
