In G1 enter =A1 and format the cell as Custom format "dd mmm yy" (without
the quotes)

or in G1 enter:

=TEXT(A1,"dd mmm yy")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Patrick C. Simonds" wrote in message
...
I have a date in cell A1 I need the date to also appear in cell G1 as text,
formatted as dd mmm yy. Any thoughts on how this might be done?