Why is Excel Format dropping trailing 00?

[lscheepers01]

Example, I enter 497000 and the cell defaults to 4970 despite having the correct formatting, Please advise on how to set the correct format for all my new Excel Spreadsheets

[#2 · Accepted solution]

@lscheepers01 

Automatically insert a decimal point 

[#3]

Thank you very much Detlef, problem solved