I have some sample data (probably from a database, originally), transmitted to me in Excel. Every field in the spread sheet has Excel type "text".
Import converts everything to type String in Mathematica. Applying ToExpression to the values with Head String does the right thing - converting to Head Integer, Real, or String - EXCEPT for one case.
In[667]:= tripleStore2[[8, 3]]
Out[667]= "8.9012234042552939E-3"
In[668]:= ToExpression[%]
Out[668]= 21.196
I'm assuming Mathematica sees "E" as the base of natural logarithms ... ?
Before I try to write the appropriate micro-parser, is there a Mathematica function I can use? Or is there code somewhere that does what I need?
Thank you, -- Mark