>>Hi All,
>>
>>I am using Excel automation to populate some cells with data. How can I tell Excel to format a cell as character before sending through the data?
>>
>>Thanks
>
>Hi. What Sergey states is what I usually do, too. Another alternative is to FIRST change the cell format to Text, THEN insert the value.
OK, how do I change the cell format to text first ?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.