Firstly have you read the help section about dealing with and converting Scientific notation?
If you use the VAL() function as suggested there you can get the value to 2.000000000 at the maximum of 9 decimal places. Of course you would need a calcualted field to convert to numeric and then re-convert to character to be compatible with other non-numeric fields.
I think you may be struggliong to get the decimal values of the E value in your example since there is a limit of 9 decimal places possible.
If that is not the problem I would check you input options for decimal place identifier character in case that is having an influence here.