Problem inserting numbers into Excel

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

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

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

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