In these spread sheets I have an entire column of values that are supposed to be dates, such as.
200701 = 1/1/2007 200702 = 2/1/2007 200905 = 5/1/2009
And so on and so forth.
These will all be in column B (if that matters) and I was curious if there is a simple way to convert these into the desired date without doing a search and replace. Some of these spreadsheets are thousands upon thousands of pages long and it will be very time consuming.