storing strings and numbers in a spreadsheet

[acgraham]

in this file i understand that the data types are incorrect. but what i dont know is how to fix it so i can write arrays filled with strings and arrays filled with numbers to seperate columns in an excel spreadsheet.

[acgraham]

sorry the file is here.

[Dennis_Knutson]

Do NOT link to third-party web sites. Attach your VI directly to your post. It's very simple to click on the 'Add Attachments below the message body.

If I understand your question correctly, you simply have to convert to a common data type. For example, you can use the function Number to Fractional String to convert a DBL array to a string array.

[acgraham]

sorty here it is.  thanks.

[Dennis_Knutson · Accepted solution]

My suggestion will work just fine. Insert the function I mentioned into each of the DBL arrays right before the Build Array.