How to move the decimal point to left in Excel?
Supposing, you have a list of whole numbers which you need to move the decimal point to left with two digits as following screenshot shown. Do you have any good ways for solving it in Excel?
In Excel, the Format Cells feature can help you to move the decimal point to left, please do with this:
1. Select the cells that you want to move the decimal point, and then right-click to choose the Format Cells from the context menu, in the Format Cells dialog box, under the Number tab, click Custom in the Category list box, and enter 0"."00 into the Type text box, see screenshot:
2. Then click OK button, and the decimal has been moved to left with two points, see screenshot:
Here is a formula also can help you to move the decimal point to left, please do as follows:
Enter this formula: =LEFT(A2,LEN(A2)-2)&"."&RIGHT((SUBSTITUTE(A2,".00","")),2) into a blank cell where you want to output the result, and then drag the fill handle down to the cells that you want to fill this formula, and you will get the following result as you need:
Note: The above methods just can be applied to whole numbers.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 9 months agoTHANK YOU SOOOOOOOOOO MUCH
- To post as a guest, your comment is unpublished.· 1 years agoAm I really missing something here?
Can't you just use "=A2/100"
- To post as a guest, your comment is unpublished.· 1 years agoHello,
the formula =A2/100 can work for some numbers, but, if there are some whole numbers, such as 20000, this formula will not work correctly.