Need to change text data in excel spreadsheet

[StevenHowell]

Good morning,

I am working on an application where there are many different datatypes being saved to a spreadsheet. Before the data is stored, it is converted to an array of strings and then sent to the spreadsheet. The only issue is that there are the little error exclamation points showing up in excel when looking at the data, and the end user cannot build graphs and other items to view the data. Is there a LabVIEW command that can tell Excel to treat all incoming text data as numeric when storing? I am not using the report gen toolkit, this was something build custom through activeX.

[nyc_(is_out_of_here)]

exclamation points?

Can you post a screen capture?

[StevenHowell]

nevermind, I figured out what I needed.

[kosist90]

And what was the solution, please? I have now a similar problem, that numeric data is stored as text in Excel...

[4Matted]

Kosist90,

I realize you were posting to this forum in hopes the original author would be helpful. If you are not able to get the answers you need here I would highly recommend creating a new discussion. Newer discussions often get stronger community responses and hopefully someone in the community will be able to assist you with whatever issues you may be having.