Re: Data Export to Excel, Reals or now Strings?

*To*: mathgroup at smc.vnet.net*Subject*: [mg78282] Re: Data Export to Excel, Reals or now Strings?*From*: Bill Rowe <readnewsciv at sbcglobal.net>*Date*: Wed, 27 Jun 2007 05:35:21 -0400 (EDT)

On 6/26/07 at 4:34 AM, kristophs.post at web.de (kristoph) wrote: >I exported simulated data to manipulate it in excel. The problem >that I have is that sometimes not always a data point is exported >to excel like the following: >00000000000000000000000000000000000000000000000000000000000000000000 >0000000000000000000000000000 >00000000000000000000000000000000000000000000000000000000000000000000 >0000000000000000000000000000 >00000000000000000000000000000000000000000000000000000000000000000000 >0000000000000000000000000000 >00000000000000000000000000000000000000000000000000000000000010923543 >112535720334421513 (this is suppose to be one number) >instead of 1.09235431125357203344215132`15.954589770191042*^-349 >which is the result calculated by Mathematica 5.2. >I would like to import the data back to Mathematica after the >manipulations which result in errors during calculations since some >of the data point, like the one above are now stings and not reals. I am fairly certain the issue here is the number being exported is not something that can be represented as a machine number on your system. On my system: In[3]:= {$MinMachineNumber, $MaxMachineNumber} Out[3]= {2.2250738585072014*^-308, 1.7976931348623157*^308} anything outside of this range cannot be represented by a machine number. Consequently, Mathematica has no simple and obvious way to do what you appear to want. -- To reply via email subtract one hundred and four