On Thu, 16 Mar 2006 16:36:30 -0800, Simon Le Page <Simon Le
wrote:

Hello,
I need to create a forumula to change the date format from 2/12 to display
the day & date "Mon 2 Dec"
Thank You

Obviously depends on the year, but if your date is a standard Excel date, then

Format/Cells/Number Custom Type: ddd d mmm


--ron