Jul 20 2021 02:47 AM
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, dann gibt mir Excel wieder die 500. Das kann aber nicht die Lösung sein.
Kann mir jemand sagen, wie ich dieses Problem löse?
Jul 20 2021 02:59 AM
Solution@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.
Jul 20 2021 02:59 AM
Solution@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.