Need Percentage in Decimal
- Thread starter Techtrend
- Start date
Asheesh
Excel Ninja
Hi Narendra,
Do the following..
1) Select range E2 to E10..
2) Press CTRL + 1
3) On the Format Cells dialog box..Select Number Tab(1st tab)
4) Then in "Category" section..select percentage
5) On the right hand side, In decimal places section..type the number of decimals you want in column E. suppose you want 2..see the image below
Do the following..
1) Select range E2 to E10..
2) Press CTRL + 1
3) On the Format Cells dialog box..Select Number Tab(1st tab)
4) Then in "Category" section..select percentage
5) On the right hand side, In decimal places section..type the number of decimals you want in column E. suppose you want 2..see the image below