Few of questions
1) I have an embedded device pumping time data in excel using a format like
xxxUS, xxxMS, & xxxKS. How can I format the cells to understand the data as
numbers so I can plot it. Right now excel interprets it as text, I have
tried different cell formatting but no luck.

2) I am adding the above data from a VBScript using format like
objXL.Cells(x, y).Value = timedata. Is there a shortcut way from VBScript to
specify something like Sheet!Row:Column=Data in one shot.

3) The data comes from embedded device in a format like
"\$Excel\~Sheet\~Row\~Col\~Data\$". I am using regexp with a pattern
"\\\$|\\~" to parse it in subcomponents. Is there a .Net equivalent to
..Split() in vbscript to create a collection of subcomponents.


Thanks