Import text file with custom number format

[Ghaug]

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

 

[Joe4]

Welcome to the Board!

You need to convert them to values.
One easy way of doing this is after importing the file, select that column with those values are replace "-" with "E-".
That should do it.

 

[Ghaug]

Welcome to the Board!

You need to convert them to values.
One easy way of doing this is after importing the file, select that column with those values are replace "-" with "E-".
That should do it.

Thanks, but how to you avoid negative numbers to be falsly corrected?

e.g. -1.0 to -E1.0

 

[Joe4]

What do your values look like?

If the first number after the "-" is always "0", then replace "-0" with "E-0".