Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to remove all decimal points but retain value in Excel?
Excel's versatile conditional formatting feature allows users to analyze and visualize data in a more organized and impactful manner. However, at times it becomes necessary to remove or modify these applied rules swiftly. In this article, we will explore effective methods that will help us clear to remove all decimal places in Excel effortlessly without compromising accuracy or productivity. Users would eliminate all decimal points by using the formula. By leveraging these powerful formulas, Power Query merging, or even going beyond with VBA macros—users are well-equipped to save time and effort while uncovering valuable insights from their data.
Example 1: To remove all decimal points but retain value in Excel
Step 1
In the Excel sheet, place the pointer in cell D2 and enter the formula to remove the decimal point for cell C2. To enter the formula, we have to select the cell that is present in the formula, then enter the formula that is =INT(C2*100) and press "Enter" tab that will remove or delete the decimal point in cell D2 for the student score that is created in the sheet as shown below.
Step 2
In the Excel sheet, place the pointer in cell D3 and enter the formula to remove the decimal point for cell C3. To enter the formula, we have to select the cell which is present in the formula, then, enter the formula that is =INT(C3*100) and press enter tab that will remove or delete the decimal point in cell D3 for the student score that is created in the sheet as shown below.
Step 3
In the Excel sheet, place the pointer in cell D4 and enter the formula to remove the decimal point for cell C4. To enter the formula, we have to select the cell that is present in the formula, then, enter the formula that is =INT(C4*100) and press the Enter tab that will remove or delete the decimal point in cell D4 for the student score that is created in the sheet as shown below.
Step 4
In the Excel sheet, we must drag the Retain value using the fill handle tool to cell D10 then it will automatically remove decimal points in row D as shown below.
Conclusion
We may use the formula to remove the decimal points in the score list of the students which will select all of the cells at the same time. They must practice the vital choices from the ribbon and update the data.
82 Views
