I have a few columns that are dates YYYYMMDD (text from WooCommerce export). I need to format them as any kind of excel date. Preferable YYYY-MM-DD. My years go back at least 50 and I am dealing with a little over 20k line items. Below is a snippet of my CSV file.
TIA,
Jon
Date
20160708
20160708
20091007
20100907
20100511
20110705
20090806
20120215
20100326
=+DATE(LEFT(A1,4),MID(A1,5,2),CLEAN(RIGHT(A1,2)))
the format of your date can be changed by clicking right Format Cells
This worked for me.
Select the range of dates
Goto the Data tab>Text to columns
Click Next twice
In step 3 of the userform under Data column format select Date
From the drop down list select YMD
Click Finish
Format in the date style of your choice.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks @Tony Valco
The only thing I needed to do in addition to your perfect suggestions was to format them as UK English YYYY-MM-DD
Thanks again all
jon
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks