How Change Percentage format to Normal Number format in Excel

1. Select the Cells which contains the Percentage values Like
10%
20%
30%
2. Change the Number format to General and data will appear like
0.1
0.2
0.3
3. Enter the Number 100 in any cell and Copy this Number.
4. Select the Cells with Decimal values.
5. Select Paste Special and Multiplication option in Paste Special Dialog box.
6. Decimal number will change to Whole Numbers like
10
20
30

Keep Learning
Win Corporate
Website: http://www.wincorptrg.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432

Advertisements