% Doesn't Display Correctly

  • Thread starter Thread starter laureny55
  • Start date Start date
L

laureny55

Hello,

This may be an easy fix, but I'm having trouble. I have a cell where
I want to input a percentage. I have the cell formatted for
percentage, so when I enter "15," the cell displays it as 15%. Then
if I enter "20," the cell displays 200% instead of 20%. Also, if I
enter ".5", the cell displays it the same as if I entered "50" and I
get 50% instead of 0.5%. Any suggestions?

Thanks,

Lauren
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top