SOLVED
Home

Problems with numeric entries

%3CLINGO-SUB%20id%3D%22lingo-sub-269200%22%20slang%3D%22en-US%22%3EProblems%20with%20numeric%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269200%22%20slang%3D%22en-US%22%3E%3CP%3EAll%20numeric%20entries%20in%20a%20new%20sheet%20are%20divided%20by%20ten.%20If%20I%20force%20the%20format%20cell%20as%20General%20(no%20numeric)%20it%20doesn%C2%B4t%20change.%20It%20occurs%20after%20the%20installation%20of%20last%26nbsp%3Bupdate.%20IT%20is%20impossible%20to%20work%20with%20this%20problem.%20Many%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-269200%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269244%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20numeric%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269244%22%20slang%3D%22en-US%22%3E%3CP%3EProblem%20solved.%20Now%20everything%20is%20OK%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20to%20all%2C%20specially%20to%20Sergei%20Baklan%3C%2FP%3E%3CP%3EThe%20setting%20was%20checked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269239%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20numeric%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269239%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20be%20sure%20this%20setting%20is%20uncheked%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20560px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F55928i9A3D6E777E5E817E%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-269234%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20numeric%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269234%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much%20for%20your%20quick%20reply.%3C%2FP%3E%3CP%3EI%20can%20Avoid%20the%20problem%20in%20this%20strange%20way%3A%3C%2FP%3E%3CP%3EI%20select%20a%20group%20of%20cells%2C%20no%20the%20complete%20sheet%2C%20and%20I%20choose%20the%20format%20%22Text%22%3C%2FP%3E%3CP%3EI%20write%20several%20numbers%20and%20after%20I%20change%20this%20group%20to%20the%20format%20%22Number%22.%20It%20appears%20a%20notification%20of%20error%20and%20if%20I%20choose%20%22To%20convert%20to%20a%20number%22.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20I%20have%20to%20do%20that%20for%20every%20cell%20in%20wich%20I%20write%20any%20number%2C%20formula.%20etc..%26nbsp%3B%3C%2FP%3E%3CP%3EImpossible%20too%20work%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269216%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20with%20numeric%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269216%22%20slang%3D%22en-US%22%3ECan%20you%20attach%20a%20workbook%20with%20a%20couple%20of%20numbers%20demonstrating%20the%20problem%3F%20(add%20text%20next%20to%20the%20cells%20explaining%20what%20precisely%20was%20entered)%3C%2FLINGO-BODY%3E
Fernando Romero
New Contributor

All numeric entries in a new sheet are divided by ten. If I force the format cell as General (no numeric) it doesn´t change. It occurs after the installation of last update. IT is impossible to work with this problem. Many thanks

4 Replies
Can you attach a workbook with a couple of numbers demonstrating the problem? (add text next to the cells explaining what precisely was entered)

Thank you very much for your quick reply.

I can Avoid the problem in this strange way:

I select a group of cells, no the complete sheet, and I choose the format "Text"

I write several numbers and after I change this group to the format "Number". It appears a notification of error and if I choose "To convert to a number". 

The problem is that I have to do that for every cell in wich I write any number, formula. etc.. 

Impossible too work 

Solution

Please be sure this setting is uncheked

image.png

Problem solved. Now everything is OK

Thank you very much to all, specially to Sergei Baklan

The setting was checked.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 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