Quote Originally Posted by girish_akki
Hi,

How to label a % symbol for a number.

Ex- I need 63 as 63% in a cell
Hi girish_akki

If you type 63 into a cell then press the % icon, it becomes 6300%, but if you select another cell and press the % icon first, then type in 63 then it is displayed as 63%.

So the morale of the story is, is to format first, then enter your numbers

oldchippy