Converting dates

[DataGraham]

Hi all

I have dates like:

1st January 2009

14th January 2009

How can I change them to look like

Thursday/01/Jan/2009

In A1 and A2

Thanks in advance

Graham

 

[Kiwiman]

Howzit

If the dates are actual numbes, you can you apply a custom format to it - "dddd/dd/mmm/yyyy"