Right now it only shows to 4 decimal places. I want it to write all (or as many as possible) decimal figures and if necessary in scientific notation.
Please let me know if this can be done.
What do you have wired up to the format input at the top of the VI? If it is unwired, it defaults to %.3f which is 3 decimal places. For other formats, check the help file.
If you cannot format the data the way you want using the format string input to the Write to Spreadsheet File.vi, then format the data to a string yourself. Use the Write to Text File.vi to write the formatted string to the file. We wrote some rather complicated file formats long before the Write to Spreadsheet File.vi was available.
Is there any way to write exactly how the numbers and letters appear in the array prior?
(CCT would have done that differernt)
Use the format string property on an element of the array
Note that a double has about fifteen digits of resolution (timestamps have about thirty). Make sure you save as much resolution as you need (max about fifteen digits for DBL data type - Excel will not handle any more, in any case).