I can't get my database imports into a format Excel will automatically recognize as a date.
They all look like this:
20121101
20121001
20120901 etc...
The day is actually immatterial; it's always the first. I only need the month and year.
I tried recording a macro that would rewrite the date, but it just did the same thing in every cell (and didn't seem to serve the ultimate purpose of of making the cells date-recognizable under the "format cell" option any way).
Thanks for any help you can provide!
-Travis
Bookmarks