I was given a spreadsheet and the date is displayed 20130821 as today for example. I need to format the dates to read Aug-21 but can't for the life of me figure this out. Any help will be appreciated.
I was given a spreadsheet and the date is displayed 20130821 as today for example. I need to format the dates to read Aug-21 but can't for the life of me figure this out. Any help will be appreciated.
Hi and welcome to the forum
if that is indeed exactly what your date looks like, then it is not exactly a date, but text (or a regular number) that just looks like a date - a date in excel is really a 5-digit number representing how many days have passed since 1/1/1900.
To convert that to a date, use this, andthen format as required...
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
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
Or =--TEXT(A1,"00-00-00")
Format the result as mmm-dd
Entia non sunt multiplicanda sine necessitate
Try this..
Data-- Text to Columns --Delimited by -- Next -- Next -- Date -- YMD -- Finish
Format cell as mmm-dd
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks