Try this in G1:

=Text(A1,"dd mmm yy")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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?