How do i convert dates to text but keep the date format
In a helper column................
=TEXT(A1,"mmmm-dd-yyyy")
You choose the format within the double quotes
Copy and paste special(in place)valuesokesc
Delete column A
Or copy and paste special(onto column A)
Gord Dibben MS Excel MVP
On Tue, 13 Apr 2010 13:21:01 -0700, SallyP
wrote:
hi, have a series of dates but everytime i try converting them to text a
number comes up. How can I convert my dates to text but keep the date format.
Please Help
|