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 Move the Decimal Point to Left in Excel?
Powerful software like Microsoft Excel provides a variety of features for analysing and manipulating data. The formatting of numbers, such as shifting the decimal point to the left, is one of the frequent operations carried out in Excel. You will be guided through the process of moving the decimal point in Excel in this lesson, allowing you to successfully change numerical data and present it in the correct format.
Knowing how to move the decimal point to the left can be very useful when working with financial data, doing calculations, or creating reports. You can alter a number's scale or precision by changing the decimal position, which makes it simpler to work with huge quantities or accurately express percentages, ratios, or monetary sums. Let's get started and learn how to complete this assignment using numerous methods step-by-step!
Move the Decimal Point to Left
Here we will first select the range of cells and then format them to complete the task. So let us see a simple process to know how you can move the decimal point to the left in Excel.
Step 1
Consider an Excel sheet where you have a list of numerical values similar to the below image.
First, select the range of cells, then right-click and select format cells.
Step 2
Then click on general, enter the type as 0"."00 and click OK to complete the task.
General > Type > Ok.
Then you will see that the decimal point will be moved.
This is how you can move the decimal point to the left in Excel.
Conclusion
In this tutorial, we have used a simple example to demonstrate how you can move the decimal point to the left in Excel to highlight a particular set of data.
345 Views
