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

[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

 

[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

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.