All articles with 'percetage format' Tag
{ 11 Comments }
Fix Incorrect Percentages with this Paste-Special Trick
Published on Jan 29, 2010 in Excel Howtos
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 »