I have a PostDate column on a spreadsheet that has the following format: 20121031
The first four characters are the year, characters 5 and 6 are for the month, and characters 7 and 8 are for the day value.
I need to create a new column that copies the values from the values in the PostDate column, but uses the following date format 10-31-2012. How can i do this?
Thanks in advance,