When you use Microsoft Excel, You will sometimes find that the numbers are not calculated properly. This is mainly because of the cell format.
Excel accepts Text and the Number input, it has the great capability to interpret between two. All the Excel cells are in General format, when you start working on any Excel sheet It automatically allots the format to each cell based on the characters inside.
If you see any cells containing the numbers but are aligned left side, you need to understand that the cell format is in Text mode. Whenever you see the numbers in any cells arranged in right side, The cell format is in Number.
The calculation only works if you have the cell in numbers format
You can change the format from Text to Number by following the method below
Click on any empty cell and right click
Choose cell formatting
You will see a menu opening as seen below
Under the Number Tab, Click number as shown in the image
Choose the decimal you want to have, make it ‘0’ if you do not want any decimal
Click OK to save
Now type ‘1’ in the cell that you have changed the format, Press enter
Then copy the cell
Now select all the cells that you want to be changed to Number formatting
Then right click and choose Paste Special
Excel will give you Paste special Options as seen below
Choose Multiply
Then click OK, Do not change any other values
Now you will see all the selected cell formatting changed to Numbers and Excel automatically aligns the numbers to the right side
Now your calculation should work
If you have any questions or suggestions, please post a comment
Read More Tips and Tricks from our website
It will be hard sometimes to find the duplicates in a spreadsheet. There is no easy way to do it. Expert have designed many macros but not everyone can buy it.
