Why is Excel Format dropping trailing 00?

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