I can't format text data saved to Excel.

[bfeddeck]

I am using the attached VI to write text data to an Excel file. The problem is I can't reformat the numeric data to create charts.

Can someone shed some light on this?

[MikeS81]

Hi bfeddeck,

which columns do you want to use in your chart?

Mike

[bfeddeck]

It will be the numeric data like "P0 Dyn" or "P1 Dyn". If I click on the cells in Excel and try to format them to numeric, nothing happens. If I save the file as a text file and then back to Excel, I can then reformat them to numeric.

Bert

[smercurio_fc]

The reason for this is that those cells have been stored as text. This is indicated by the little triangle in the upper left of the cell. The reason for this is that in your code you are creating a 2D array of strings and writing that out. Excel directly treats this as text information, and not numerical information. If you wish to treat those value as numeric then you need to select the entire range of cells and then click on the little yellow icon to display the context menu:

 

You can also change the way you're writing out the data by using numerical arrays for those columns. This would mean writing out the columns in sections rather than all at once.

Message Edited by smercurio_fc on 09-08-2008 10:17 AM

[bfeddeck]

I am using Excel 2003 and I don't have the little yellow icon when I select the cells. I have seen this before and I know what your talking about. Is there a feature within Excel I need to turn ON?

Bert

[bfeddeck]

Never mind I found it.

Thanks for the help.

Bert