Hello Simon Le Page,

You can use a Custom Number Format:

Highlight the dates and choose Format + Cells + Number Tab.
Choose Custom and type the following into the text box:

ddd d mmm

Post back if you have any problems

Judith
--
Hope this helps


"Simon Le Page" 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