Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formating questions
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Excel '07 Questions | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Excel/VBA Questions | Excel Programming |