The number change from 1350 to 13.5 and Enter does not function properly

H

hon123456

Dear all,

I got two problems in using the excel,

First is when I type in a number like 1350, excel will change
it to 13.5
ehat happened and any setting that I need to make it back to normal.

Second is that when I finish entering data in cell and Press
Enter button, it should go down to another cell, but now when I press
Enter, it just stay in the same cell and do not move to any cell.

Please help. Thanks.
 
J

JulieD

Hi

for your first question choose
tools / options / edit and untick fixed decimals

for the second
tools / options / edit and tick move selection after enter and choose Down

Cheers
JulieD
 
Top