07-19-2011 03:51 PM
I think I might have confused you when I said "array to spreadsheet vi".
What I meant was to stay with the "write to spreadsheet file vi" that you were already using but try the %s format string
07-20-2011 08:30 AM
That works to an extent but not fully. The readout becomes something like: 0.00000744.237301128.000000 which when split up is 7e-6, 44.23, and 128.0 So I guess my next question is do I have to change to formatting differently instead of the delimeter %s to format in such a way that the first number carries more than those 6 digits before the actual number? In other words it should read out something like 7.19e-6 or with all of the 0's in front instead of cutting off at the first digit of 7.
07-20-2011 09:27 AM
With the small numbers yo uare working with I would (and gennerally always do) use Double-precision floating-point numbers.
As for the format, once you get in into Excel you can format the numbers anyway you want.
Select a colum or group of numbers, right click on it and select "format cells".
07-20-2011 10:32 AM - edited 07-20-2011 10:33 AM
Yeah it was not about formatting in excel it was how it was formatted in the spreadsheet text file. Using the scientific notation format instead of the %s format I am having no problems now. Thanks for all of your help. I believe all of my issues have been solved for now. Thanks again to all who helped.