Forum Discussion

andreguenter's avatar
andreguenter
Copper Contributor
Jul 20, 2021
Solved

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...
  • Riny_van_Eekelen's avatar
    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.

Resources