Forum Discussion

Fernando Romero's avatar
Fernando Romero
Copper Contributor
Oct 10, 2018
Solved

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 with this problem. Many thanks

excel

4 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Oct 10, 2018
    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's avatar
      Fernando Romero
      Copper Contributor
      Oct 10, 2018

      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 

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Oct 10, 2018

        Please be sure this setting is uncheked

Resources