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 Romero
Oct 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.