Two possibles...

Just add a custom format. Right click the date and select Format Cells -
Number tab - Custom and change the format to ddmmyy

Or use the formula
=text(a1, "ddmmyy")
where your date is in A1.
--
HTH...

Jim Thomlinson


"jsv" wrote:

How do I convert 02/11/09 to 021109?

Thanks