Backspace and percentage, please help

  • Thread starter Thread starter broogle
  • Start date Start date
B

broogle

Is this a bug in excel ????

Please try this :

Key any number in any cell (let say I put no 1).

then change the format to percentage.

Keep the cursor in that position, now hit backspace then key any number
1, 2,3,100, etc, as you can see the result will be multiply by 100,
meaning : before it was 1% and after backspace it became 100%, please
explain. Heaps of thanks !!!
 
It works the opposite for me, and that is what I would expect.

I enter 1, then format as percentage, and it says 100%.
Backspace, and enter 1 and it says 1%.

I can see that as OK< because the cell is formatted as a percentage, so
Excel sees that a number 1 is meant as 1%. Formatting afterwards, it sees
the 1 as a whole, 100%.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Similar Threads

help with generating a percentage value 4
Backspace should remove bullet AND go to previous paragraph 1
Problem entering percentage on form 5
Probelm with Delete Key in ActiveX in Access Form 2
Keyboard Shortcuts for Justification 2
backspace key not working on bullets 3
BACKSPACE bug??? 3
Adding Fractions and Displaying as a percentage. 6

Back
Top