Amount is divided by 100

G

Guest

Hi,

One of my colleagues is having a strange problem: when he types a number in
excel 2003, the number is systematically divided by 100. I can't figure out
what is going on. Has anyone ever experienced this?

Thanks,
Kanga
 
G

Guest

Probably Tools/Options/Edit tab, Number of Decimal digits is set to +2.
Set it to 0.
Regards,
Stefi
 

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

Number automatically divided by 100, why? 4
numbers are being divided by 100 on leaving cell 4
illegal division by 100 2
Number entries are automatically divided by 100 - Excel 2003 1
All Numbers entered divided by 100,000,000,000! 3
Numbers divide by 10 in any cell... 6
Number entered in cell getting always divided by 100 ! 5
Typed numbers are divided by 10 (Excel 2007) 2

Top