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
Re: Problem inserting numbers into Excel
Show me the code that you are using to put the data in Excel?
Re: Problem inserting numbers into Excel
You could format the cells once you insert the data as well, and skip the notepad step.
Re: Problem inserting numbers into Excel
search in office development, anhn has posted a formula to convert text to values