I have a column of dates formatted as:
20130201
The cell format in the column is General.
I need to change it so that the format looks like this:
02/01/2013
Is there a quick/easy way to do this in Excel 2010?
I have a column of dates formatted as:
20130201
The cell format in the column is General.
I need to change it so that the format looks like this:
02/01/2013
Is there a quick/easy way to do this in Excel 2010?
Do this..
Data-- Text to Columns --Delimited by -- Next -- Next -- Date -- YMD(or YDM as the case maybe)-- Finish
Format cell as dd/mm/yyyy or mm/dd/yyyy as required
Life's a spreadsheet, Excel!
Say thanks, Click *
Try this...
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
Format as required
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks