Hi, p45cal

Sorry for being a bit dense!

So each Monday, IT send us the csv which has been generated from our online database of addresses. We don't export anything. When we double click the csv it opens in Excel. IT have provided us with a notepad version of this to help us with the formatting but it's not been that helpful.

So conversion has happened prior to them sending us the csv.

What we want to do is format the dates that should be flat numbers?

My organisation's firewall will not allow me to open your dropbox link.

Does the above information help at all?

Thanks for everything and the quick responses :-)

Lynn