I have dates entered like 20051214. How do I format them so that Excel will recognize as a date?
C Cindy Smith Jan 12, 2006 #1 I have dates entered like 20051214. How do I format them so that Excel will recognize as a date?
P pinmaster Jan 12, 2006 #2 Select the column with dates, go to Data/Text to Columns...select Fixed Width then NEXT NEXT now select Date from the option on the top right corner and from the drop down menu select YMD. hit Finish. HTH JG
Select the column with dates, go to Data/Text to Columns...select Fixed Width then NEXT NEXT now select Date from the option on the top right corner and from the drop down menu select YMD. hit Finish. HTH JG
P pinmaster Jan 12, 2006 #3 Hi Cindy Instead of selecting the whole column select the range of cells only, seleting the whole column might have some undisreable effect. Regards JG
Hi Cindy Instead of selecting the whole column select the range of cells only, seleting the whole column might have some undisreable effect. Regards JG
