Forum Discussion
Fernando Romero
Oct 10, 2018Copper Contributor
Problems with numeric entries
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 ...
- Oct 10, 2018
Please be sure this setting is uncheked
JKPieterse
Oct 10, 2018Silver Contributor
Can you attach a workbook with a couple of numbers demonstrating the problem? (add text next to the cells explaining what precisely was entered)
- Fernando RomeroOct 10, 2018Copper Contributor
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
- SergeiBaklanOct 10, 2018Diamond Contributor
Please be sure this setting is uncheked
- Fernando RomeroOct 10, 2018Copper Contributor
Problem solved. Now everything is OK
Thank you very much to all, specially to Sergei Baklan
The setting was checked.