I have a column full of cells that all have the same string with a few different numbers. Here is an example from cell K319:
What I need to do is extract the last 8 characters (eg. 12/06/09) and turn those into a proper date displaying as "December 06, 2009"
What I tried to do is use the function: =RIGHT(K319,8) which gives me the 8 digits, but I can't get Excel to display that date as December, 06, 2009 because it keeps wanting to think that the middle digits is the month and it always spits out "June 12, 2009". I've tried formatting the cells every which way and can't figure it out.