Excel 2000 numbers issue

by choy.waigiat . Updated 21 years ago

When I key in numbers like 100000 and press Enter, it will automatically change to 100. The zeros will be reduce.

advise anyone?