SOLVED
Home

Datenprüfung

%3CLINGO-SUB%20id%3D%22lingo-sub-636815%22%20slang%3D%22de-DE%22%3EData%20verification%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636815%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Excel%20365%20ProPlus%20on%20the%20computer%20and%20for%20a%20number%20of%20cells%20I%20wanted%20to%20restrict%20the%20input%20area%20to%20a%20list%20of%20values%200.1%3B%200.2%3B%200.3%3B%200.4%3B%200.5%3B%200.6%3B%200.6%3B%200.7%3B%200.8%3B%200.9%3B%201.0.%20Have%20done%20everything%20as%20described%20in%20the%20help%2C%20but%20if%20I%20enter%20a%20value%20of%200.15%20by%20keyboard%2C%20it%20will%20be%20accepted.%20The%20cell%20shows%200.2%20(number%20with%20a%20descendant%20is%20set)%2C%20but%20the%20contents%20are%200.15.%20By%20checking%20data%2C%20I%20are%20barred%20from%20entering%20negative%20values%2C%20but%20why%2C%20for%20example%2C%20may%20I%20Enter%200.15%3F%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20answer%20in%20advance.%3C%2FP%3E%3CP%3ESlawomir%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-636815%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-636887%22%20slang%3D%22en-US%22%3ERe%3A%20Datenpr%C3%BCfung%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636887%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F347213%22%20target%3D%22_blank%22%3E%40SlawomirLebida%3C%2FA%3E%26nbsp%3B%2C%20what%20exactly%20did%20you%20do%3F%20It%20works%20as%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-636929%22%20slang%3D%22de-DE%22%3ERe%3A%20Data%20check%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636929%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20it%20like%20I%20put%20it%20on.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-636972%22%20slang%3D%22en-US%22%3ERe%3A%20Datenpr%C3%BCfung%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F347213%22%20target%3D%22_blank%22%3E%40SlawomirLebida%3C%2FA%3E%26nbsp%3B%2C%20and%20what%20is%20on%20the%20third%20tab%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20392px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F115791iAAF088A243A537DB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-637030%22%20slang%3D%22de-DE%22%3ERe%3A%20Data%20check%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-637030%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppendeaonating%20to%20the%20third%20tab.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-637056%22%20slang%3D%22en-US%22%3ERe%3A%20Datenpr%C3%BCfung%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-637056%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F347213%22%20target%3D%22_blank%22%3E%40SlawomirLebida%3C%2FA%3E%26nbsp%3B%2C%20I%20repeated%20literally%2C%20it%20works.%20But%20I'm%20in%20English%20locale%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20356px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F115795i50F85C9FD726BE40%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20407px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F115796i8D31143B01CC32CD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
SlawomirLebida
New Contributor

Hallo,

 

ich habe Excel 365 ProPlus auf dem Rechner und habe für eine Reihe von Zellen den Eingabebereich auf eine Liste aus Werten 0,1;0,2;0,3;0,4;0,5;0,6;0,7;0,8;0,9;1,0 einschränken wollen. Habe alles so wie in der Hilfe beschrieben gemacht, wenn ich jedoch per Tastatur Eingabe ein Wert von 0,15 eingebe, wird er akzeptiert. Die Zelle zeigt zwar 0,2 an (Zahl mit einer Nachkommastelle ist eingestellt), der Inhalt ist aber 0,15. Durch die Datenprüfung die Eingabe von negativen Werten verwehrt, warum aber darf ich z.B. 0,15 eingeben?

Vielen Dank für die Antwort im Voraus.

Slawomir

5 Replies

@SlawomirLebida , what exactly did you do? It works as attached

@Sergei Baklan 

 

Ich habe das so gemacht wie angehängt.

@SlawomirLebida , and what is on the third tab?

image.png

@Sergei Baklan 

Anbei das dritte Tab.

Solution

@SlawomirLebida , I repeated literally, it works. But I'm in English locale

image.png

image.png

 

Related Conversations