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