Excel is correct.

If you want to have 5%, then you should enter .05 (5 out of 100).

If you have lots to fix, you can use this technique:

Put 100 in an empty cell
Edit|copy that cell

Select the range to fix
Edit|paste special
check values and divide
Format that range as a percentage

And delete the 100 from that helper cell.

Wanna Learn wrote:

Hello I have a spreadsheet in column b there is a number when I try
to format the number to a percentange I get the wrong answer. example
column B has a 5 the answer should be 5% . but when I format the cell for
decimal I get 500.00% how do I correct this thanks column is formatted
as general

--

Dave Peterson