Dates - AArrrhhhggg

[neville]

My eternal nemesis.

I am running excel 2007. I am converting American dates to proper dates and for a while my formulas of Right, Mid & left worked I just concatenated them.
Once that was done I could not format the column to the date format I wanted DD-MMM-YY, so I copied the entire column over one and pasted as values. That also did not work.

Is there a way in excel to force a format in a column??

Rgs

Neville

 

[neville]

Thanks for that Richard works a treat.

Thanks everybody for all your suggestions.

Cheers

Neville