close
Here's an easy way:
Select your data then go to Data/Text to Columns, select quot;Fixed Widthquot; hit
NEXT NEXTX then select quot;Datequot; in the upper right corner and in the drop down
menu select YMD and hit quot;Finishquot;.
HTH
JG
quot;claricequot; wrote:
gt; how can a date that is set up in excel as 19900301 be converted automatically
gt; to read 03/01/1990?
全站熱搜
留言列表
