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

S

SteveC

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

2-Jan-97 to text 02Jan97

thanks...
 
S

SteveC

yeah, thanks Don. just figured it out:

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