How to convert text to numbers - PankoAliaksandr/Excel GitHub Wiki

Once I had the issue trying to convert numbers in text format to real numbers. The problem has been resolved using "Text to columns" button

this is explained here