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.
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
Go to Home tab and select Percent Style
Your data will change into the format shown in column B in the above image