date formatting
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
|