Search This Blog
Thursday, 12 July 2012
QUICK TIP: CONVERT THE NUMBER INTO PERCENTILE
If we want to add "%" in each cell in a column, we generally select home tab, then go to % and it converts the number in the following format.
1000%
3300%
3700%
1200%
1100%
4200%
2400%
2400%
So, this is not a right way. The quick way to do this is
Write 100 in a cell & copy itSelect the data which you want to format (In this case A1:A8)
Right click and go to Paste Special
Select divide
Press OK
Go to Home tab and select Percent Style
Your data will change into the format shown in column B in the above image
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment