HELP ( convert text channel to Numeric channel )

[itsouss97]

I'm a student in my last year of studies and I'm not that good working with scripts.

I work with Diadem to analyze my real-time data,  and when i import the excel files ( One year of data gathered in excel files separately ) into Diadem my columns change automatically to text format So i guess the solution in to write a script to convert my channels into Numeric format?

  

[itsouss97]

By the way i work with VBscript

[StefanR]

Hi data_engineer,

please re-post your topic in the discussion forum, as idea exchange is meant for new feature proposals:

https://forums.ni.com/t5/DIAdem/bd-p/60

But here's also a tip, you can "overrule" auto-detection by clicking in the cell and changing the type:

However, since data type conversion works on my end for the data in your sheet, there could be an additional issue with your xls-file. Is this really a xls-file, or did you rename a csv?