Problem with column format

S

Sciamano

Hi, I've problem, with my .NET application I copy data in my Excel existin
file. In my file I use a specific column for generate a charts.

Mi problem is that when I copy data from .NET in the xls file the column has
the "corner" with information about the format of the column... excel use
the text format for this column and the chart can't use the datas.....

How Can I modify the excel file for automatically convert the datas copyed
from .NET applicatin in number (decimal) format??

Thanks!!!
 
D

David Biddulph

Sciamano said:
Hi, I've problem, with my .NET application I copy data in my Excel existin
file. In my file I use a specific column for generate a charts.

Mi problem is that when I copy data from .NET in the xls file the column
has
the "corner" with information about the format of the column... excel use
the text format for this column and the chart can't use the datas.....

How Can I modify the excel file for automatically convert the datas copyed
from .NET applicatin in number (decimal) format??
Click to expand...

If you're trying to convert numbers entered as text to actual number values,
have you tried using Paste Special to multiply the cells in the column by 1
or to add zero?
 
S

Sciamano

But how Can apply the format change when a user open the document?? I can't
use macro because in some PC should be not active :-((
 
Top