close

I have dates entered like 20051214. How do I format them so that Excel will
recognize as a date?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

quot;Cindy Smithquot; wrote:

gt; I have dates entered like 20051214. How do I format them so that Excel will
gt; recognize as a date?
gt;

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

quot;Cindy Smithquot; wrote:

gt; I have dates entered like 20051214. How do I format them so that Excel will
gt; recognize as a date?
gt;

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()