Convert date to text
 

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?

Convert date to text
 

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?

Convert date to text
 

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?