One way:

Select your date string(s). Choose Data/Text to Columns. Click Next,
Next. Select YMD in the date dropdown. Click Finish. Format as a
date.


Note: Your example is ambigouous, so you may need to use YDM instead.

In article ,
douvid wrote:

Hi ,
I got a string like "20030101" and I want this to become the date 01 jan 03 .
I can't figure it out. Can you please help if this action is possible