Creating .DIF files with VB 6.0 (Data Interchange Format)

S

Shamblin Hamilton

I am creating a .dif file with VB to open in Excel. Some
of the data is numeric with leading zero's. When opening
in Excel I need the leading zero's to remain. How do I
create a .dif that will allow numeric data but display in
Excel as text data?

Thanks
 
B

Bob Greenblatt

I am creating a .dif file with VB to open in Excel. Some
of the data is numeric with leading zero's. When opening
in Excel I need the leading zero's to remain. How do I
create a .dif that will allow numeric data but display in
Excel as text data?

Thanks
Click to expand...
If you really want the numeric values to be text and not a quantity that
excel can use for a calculation (like a zip code), you can precede each
value with a single apostrophe. Or, you can format the column to show the
proper number of leading zeros.
 
Top