hi
you have "fixed decimal places" turned on.
in xl03, it's toolsoptionsedit tabuncheck fixed decimal places.
in xl07, i'm not sure. office buttonexcel options????
snoop around.
sorry i could not be more help. i know what the problem is, i just don't
have 07 yet.

regards
FSt1

"Don O'Hara" wrote:

When i key a random number into a cell (in MS Excel 2007)

the number will automatically divided by 100

for example:
if i key in 2000 and press ENTER, it will become 2 immediately

if i key in 50 and press ENTER, it will become 0.5 immediately


I've checked the data format. the format is "GENERAL".


Something wrong with the settings?