Google Sheets Large Numbers without Scientific Notion

Problem : Everytime you Type a large number in google sheets it starts to show in scientific notion like 1.23E+26.

Solution : Click on format as Number bar and select 0. Nothing else works.