Convert date to text

  • Thread starter Patrick C. Simonds
  • Start date
P

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?
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top