All articles with 'percetage format' Tag

Fix Incorrect Percentages with this Paste-Special Trick

Published on Jan 29, 2010 in Excel Howtos
Fix Incorrect Percentages with this Paste-Special Trick

Sometimes we get values in our Excel sheets in such a way that the % sign is omitted. So instead of the value being 23%, it is 23. Now, you can very easily correct this by editing the cell and adding a % sign at the end. But what if you have 100s of rows of data. You can’t do this to every cell. (You can not just format the cells to % format either, excel shows 23 as 2300% then). There must be some simple and intuitive solution for this … umm.

Continue »