Using OLE, I'm invoking Excel and opening a tab delimited
file. My problem is with cells that contain numbers.
Excel automatically removes leading and trailing zeroes
from cells that contain numbers. In many cases this data
represents text, such as a part number, which may contain
leading zeroes. I don't want these removed. In addition
I'd prefer that trailing zeroes on decimal numbers not be
truncated. Is there a way to tell Excel to treat the data
as text even if the contents is all numeric? I've tried
using the NumberFormat property, but I don't see any way
to prevent the removal of leading zeroes.

Thanks,
Vern

I am having exactly the same problem from Deplhi.

I have tried Numberformat:='Text' gives error 1900 in result
also tries :='@' no effect

Seen this problem reported in lots of places on the net but never wit
a suggested solution that was acknowledged as working.

Is there a solution

--
Message posted from http://www.ExcelForum.com