SOLVED

Excel Zahlen Format

%3CLINGO-SUB%20id%3D%22lingo-sub-2565100%22%20slang%3D%22de-DE%22%3EExcel%20Number%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2565100%22%20slang%3D%22de-DE%22%3E%3CP%3EDespite%20proper%20formatting%2C%20it%20always%20cuts%20off%20the%20last%20digit.%3C%2FP%3E%3CP%3EFor%20example%2C%20I%20enter%20500%20in%20the%20cell.%20Output%20in%20the%20cell%20is%2050.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20the%20moment%20I%20can%20solve%20it%20by%20typing%20500.0%2C%20then%20Excel%20gives%20me%20the%20500%20again.%20But%20that%20cannot%20be%20the%20solution.%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20tell%20me%20how%20to%20solve%20this%20problem%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2565100%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2565149%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Zahlen%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2565149%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1107874%22%20target%3D%22_blank%22%3E%40andreguenter%3C%2FA%3E%26nbsp%3BNow%2C%20I%20don't%20know%20the%20German%20menu%20options%2C%20but%20go%20to%20File%2C%20Options%2C%20Advanced.%20Under%20%22Editing%20options%22%20you'll%20find%20an%20option%20to%20%22Automatically%20insert%20a%20decimal%20point%22.%20I%20suspect%20that%20it%20is%20checked%20in%20your%20case%2C%20with%20a%201%20in%20the%20%22Places%22%20field.%20Remove%20the%20check%20mark%20and%20it%20should%20be%20solved.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2565315%22%20slang%3D%22de-DE%22%3ERe%3A%20Excel%20Number%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2565315%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20You.%20You%20are%20my%20hero%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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? 

2 Replies
best response confirmed by allyreckerman (Microsoft)
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.

@Riny_van_Eekelen Thank you. You are my hero !