Hi
Thanks for responses - sorry for my late reply.
I was indeed hoping to add something to the text file to force it to work. Adding quotes just to the code field does nothing.
I thought I'd cracked it when I found that adding a tab would actually work (it's a csv file remember) - the field came into Excel as text, with leading zero preserved.
However, while this worked for Excel, it's sod's law that the other program I was trying to get a solution for still brought the field in as a number, and stripped the zero.
So I offer this solution up to anyone who has this issue with excel, but I'll just have to keep looking for something else for my particular requirement.
Cheers!
|