Problem inserting numbers into Excel

[Guru]

I'm using VB6 to write to a worksheet in a .xls file
The data is then used in a graph on another worksheet.
The problem is that the data I'm inserting is being treated as text (left aligns) causing the graph to be blank.

If I cut the data from the worksheet, paste into Notepad and then copy & paste it back, it all works fine

Any ideas how I can get it to be handled as numeric?


Thanks

[Siddharth Rout]

Show me the code that you are using to put the data in Excel?

[vbfbryce]

You could format the cells once you insert the data as well, and skip the notepad step.

[westconn1]

search in office development, anhn has posted a formula to convert text to values