Problem concerning cell formats
Posted by Charlene on October 19, 2001 11:19 AM
I have roughly 5000 cells that I need excel to recognize the text as percentages for. I select them all, right click --> format cells, and change the number format to percentage. I click OK, and nothing happens. However, when I 'look' at a cell, and move to another one, it only then converts it to a percentage. Double-clicking on 5000 cells doesn't seem practical; is there a faster way to get excel to automatically recognize them as percentages?