Forum Discussion
andreguenter
Jul 20, 2021Copper Contributor
Excel Zahlen Format
Trotz richtiger Formatierung schneidet es immer die letzte Ziffer ab. Beispiel: Ich gebe 500 in die Zelle ein. Output in der Zelle ist 50. Momentan kann ich es lösen, indem ich 500.0 eingebe, da...
- Jul 20, 2021
andreguenter Now, I don't know the German menu options, but go to File, Options, Advanced. Under "Editing options" you'll find an option to "Automatically insert a decimal point". I suspect that it is checked in your case, with a 1 in the "Places" field. Remove the check mark and it should be solved.
Riny_van_Eekelen
Jul 20, 2021Platinum Contributor
andreguenter Now, I don't know the German menu options, but go to File, Options, Advanced. Under "Editing options" you'll find an option to "Automatically insert a decimal point". I suspect that it is checked in your case, with a 1 in the "Places" field. Remove the check mark and it should be solved.
- andreguenterJul 20, 2021Copper Contributor
Riny_van_Eekelen Thank you. You are my hero !