typ 300 show 3 (in excel)

[lamyuwang]

Hi all,
as the title say, when i input any integer, e.g. 300, it will automatically change to 3 ( divide 100), 50000 to 500 ect.
but when i copy and paste the number on it, no this problem occurs.
can anyone tell me why, and also help me to slove it, because it really make me a lot trouble.
thanks~~~

 

[GlennUK]

It sounds like you've got Fixed Decimals switched on. Dom menu command Tools/Options/Edit and untick the Fixed Decimal checkbox.

Glenn.

 

[lamyuwang]

you're right~~
what you say it work.
Thanks~~