Handling values like 02E0000 (text/numeric)

[sudipballa]

I prepare load files in EXCEL, save them in TAB DELIMITED TEXT file and pass it to others who load it in applications

When i try to handle values like 02E0000, excel immediately converts it
2.00E+00. Even if i convert the format to TEXT and then put the value, it converts it to this notation. What is the ideal way for someone like me to deal with these things. One option i have is to ensure i manually insert ' before the value, but it is very cumbersome. Many times i copy paste value from other files to excel and it is not possible to do that step.

Please share your thoughts

 

[NARAYANK991]

Hi ,

Can you upload a sample Excel file or the TAB delimited text file ?

Narayan

 

[sudipballa]

Please find sample files (just with one record... i reality I have to deal with thousands of records with 10-12 fields)

 

[NARAYANK991]

Hi ,

In the file named Wrong-file.txt , the data is itself in exponential format , as :

2.00E+00

How did it get this format ?

Narayan

 

[sudipballa]

You try to type 02E0000 in an excel cell and you will understand the situation

 

[NARAYANK991]

Hi ,

If a cell is already formatted as Text , there is no problem in entering 02E0000.

Narayan