I'm sure that in previous version of excel you could format a cell as a percentage and then enter a number and it would show as that value %.
For example, format the cell to % with 2 decimal place, enter the number 5 in the cell and it would display as 5.00%.
I am unable to get this to work now and wondered if there is a way to do this with adding the trailing % symbol?
For example, format the cell to % with 2 decimal place, enter the number 5 in the cell and it would display as 5.00%.
I am unable to get this to work now and wondered if there is a way to do this with adding the trailing % symbol?