Thanks anthonya but they are in text format.
In A1 for example I have 05/01/2005 mm/dd/yyyy in date format (yes - I can format this as any date format).
I want to cut and paste that date into a txt document.
To do this I converted it to text format in another cell using the above formula but it comes out as m/d/yyyy.
Cheers Glenn