ActiveCell.Numberformat = "@"

--
Regards,
Tom Ogilvy



"Daryl" wrote:

I have a program that creates and inserts into an excel document using com.
The default format for the cells are type=general. I need to force it to
type=text so excel doesn't try formatting my data. I can't find any
documentation on how to do this, any suggestions?

ex. 179662E14 displays as 1.80E+19
note: sometimes this data views differently because the column is not open
wide enough, but this is a different issue.

thanks,
Daryl