HI all,
I have to bring in a *dbf file, do some stuff, and then save it as a text
file for a Unix system. I'm having a few problems (lack of VBA talent aside)
but one I'm stuck on is I have two columns CUSTNUM AND INVNUM that import in
a numeric format. CUSTNUM is anything from 1 to 4 digits. INVNUM IS 5 or 6
digits. I need to concatenate them to a 11 character format like this
0123-056788 (note leading zeros and hyphen). I have tried everything I can
think of (programmatically or cell formatting) yet they remain underlying as
a number and when I concatenate I lose the leading zeros so I'm stuck.

Any help and direction is always appreciated.

--
jeff