May 20 2020 05:41 AM
Hello,
I'm quite new at excel and I need your help. So I exported data from python to txt file and then I imported it to excel and the data is read by excel as text instead of numbers. I alredy try a few methods like a function VALUE or changing cell type. What can I do? Any ideas? I want to work with this numbers so i really need to convert them.
May 20 2020 06:00 AM
May 20 2020 06:21 AM
To convert those numbers into real numbers, follow these steps...
This will convert the numbers in column A to real numbers. Repeat the above steps for column B separately.
Once the numbers are converted into the real numbers, the decimal values will be truncated to two decimal places but the underlying numbers remain intact. You may increase the decimal places for these columns as per your requirement.