Re: I need my spreadsheet data to be in floating point format.
And what is the format string that you're using? And how can the data in the saved file be correct if it's integers and what you are trying to write is floats? Stick a probe on the input to array to spreadsheet and one on the output. That way you now whether you have a problem with the format string or with the data you've collected.
Re: I need my spreadsheet data to be in floating point format.
I use the array to spreadsheet string to take in the data, then I concatenate the date/time string to the end of the spreadsheet string, then I use the write characters to file vi. When I look at the data sheet I saved it under, the data is correct along with the date/time, but the data needs to be in floating point mode instead of whole intergers.
Re: I need my spreadsheet data to be in floating point format.
If you are using the 'Write to spreadsheet file.vi' then set the format connector (on the top of the vi connection in pink). Its a string with a format %[–][+][^][0][Width][.Precision][{unit}]Conversion Code But is your source data to this VI already an integer ? Perhaps you could post a diagram of your vi ?