Link to home
Start Free TrialLog in
Avatar of Ladkisson
LadkissonFlag for United States of America

asked on

Formula opposite Concatenate

Hello,

I have a text extract that needs to be converted to regular date format. For example: 02APR2017:00:00:00.000 needs to be 4/2/17

thanks!
Avatar of Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Flag of Zambia image

Just use format date and select English USA as short date, that is it




Regards

Chris
Dates-format.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ladkisson

ASKER

Perfect! Thanks!
Glad to help.