That was a fast reply

Thanks Bob


"Bob Phillips" wrote in message
...
Just format the cell as ddd-dd-mmm-yy

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"DavidM" wrote in message
...
Hi all

I have in column I dates like 5/16/2006 which show in cells as 16-May-06
how could I get them to show as, Tue-16-may-06

Thanks in advance

Dave