Convert date to text

[Patrick C. Simonds]

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?

 

[Ragdyer]

Try this in G1:

=Text(A1,"dd mmm yy")

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk