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.