yeah, thanks Don. just figured it out:

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



"Don Guillett" wrote:

can you just change the format to ddmmmyy

--
Don Guillett
SalesAid Software

"SteveC" wrote in message
...
Hi, any clue how I an transform a column of dates into a text format like
this:

2-Jan-97 to text 02Jan97

thanks...