Numeric formats

V

Vern Jorgensen

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
 
A

ashdata

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem using Match on columns of numbers with leading zeroesformatted as text ??? 4
Sorting alpha-numerically? 4
Export table to text file with numeric field to have leading zeroe 1
Leading Zero Dropped in Text Cell 3
CSV leading zeroes 2
Importing text columns in csv file 3
Paste problem from HTA 5
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5

Top