Probably not the best solution, but you could do this.

=TEXT(A1,"dd-JUL-yyyy")

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=377583