Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with column format
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!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with column format
Nobody can help me ???? :-(((((
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with column format
"Sciamano" wrote in message
... 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?? 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? -- David Biddulph |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with column format
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 :-(( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
format macro | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) |