Is this one column?

If yes, record a macro when you select that column.
choose fixed width
draw a line right before the first digit (after the "din ")
Choose ignore (Do not import) the first field
choose ymd (or myd???) for the date portion

And plop it down directly in the original location.

Alastair79 wrote:

I have a general formated cell with the following in:-

DIN 060416 (the numbers change day to day of course)

In a Macro I need to remove the "DIN" part which I can do, but as soon as I
do this it alters the format to number and shows it 60416 which if you try
and date format is completely wrong.

I need it to be 06/04/16. Any help would be much appriciated and as you can
prob tell I am rubbish on Excel ;) Alastair.

--

Dave Peterson