setting data types for excel cells in vba

[kaus]

Trying to set cell data type to text or general in vba -- using:
ObjExcel.ActiveSheet.Columns("C&quot.NumberFormat = "General"

but still makes a number defined column of cells

is there a another way

thanks

Pete

 

[rmikesmith]

Pete,

I don't quite follow what your problem is. What do you mean when you say the column is number defined?

Regards,
M. Smith

 

[xlbo]

General formats just means that the cell will pick up whatever excel thinks the entry is - text for text, number for number etc
use Numberformat = "@"
for text
HTH
Geoff