I have a large text file where the numbers are stored in a custom number format
For example 1/100 is stored as 1.0-02 in the text file and not as 1.0E-02
The imported data is transformed to text in excel "1.0-02" when I import the file
And i cant use the data for further calculation
How do i get Excel to recognise/import this as a number instead of text?
G
For example 1/100 is stored as 1.0-02 in the text file and not as 1.0E-02
The imported data is transformed to text in excel "1.0-02" when I import the file
And i cant use the data for further calculation
How do i get Excel to recognise/import this as a number instead of text?
G