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
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies