Microsoft Excel - Number Format and Changing Decimal to Percent

Not just text, but you can also format numbers that you have entered in the Excel sheet. The number formats like adding commas, specifying the decimal places, placing a sign before the number and even converting the number into percentage.

So in this post, we are going to learn the steps in formatting you number data on sheets. Just follow the simple guide format below.

Format Number

1. Click Cell B8
2. Type the numbers “12345678”
3. Choose Home tab
   
4. Click the arrow down next on Number Format box(refer to the picture above) a small menu will appear.
5. Click the number function, this will add up two decimal places on the number data you have typed.
6. You can also click the comma style to separate the thousands with comma.
   
7. You can click decimal to change the decimal places format now let us click the left decimal places direction.
8. Now let us click the right decimal places direction.

Changing Decimal to percent in Excel

1. On cell B9
2. Type “.35” (include the decimal unit)
3. Hit enter on your keyboard.
   
4. Choose Home tab
5. Click for the percent style. (this will convert decimal to percent)