How do i convert dates to text but keep the date format
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 |
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 |
All times are GMT +1. The time now is 05:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com