Amount is divided by 100

K

Kanga

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
 
S

Stefi

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

Autonumber field in Excel that behaves the same as Access 0
Cell data entering slow! 0
Slideshow with black border around it 0
Comparing two lists in Excel 1
numeric entered automatically divided 100! 1
Number automatically divided by 100, why? 4
Number entries are automatically divided by 100 - Excel 2003 1
Excel automatically divides number by 100 3

Top