Convert date format 2-Jan-97 to text 02Jan97

[Guest]

Hi, any clue how I an transform a column of dates into a text format like this:

2-Jan-97 to text 02Jan97

thanks...

 

[Don Guillett]

can you just change the format to ddmmmyy

 

[Guest]

yeah, thanks Don. just figured it out:

If date is in cell a2, then =text(a2,"ddmmmyy")