|
Huh - rereading the above, I realize I never connected with Moonie on this. But I did figure out a solution on my own: for the one date that was suspect of changing, I had the date entered elsewhere on the spreadsheet. I was able to set up conditional formatting so that if the one date ever became different than what it was supposed to be, it would flag itself.
But on to a new challenge
I have two data fields that I need to convert. Both actually looked like the second example below, but I was able to strip the time out since all records had the same time (12:00 a.m.) - a simple search and replace took care of those!
The two fields have the data as "Apr 30 2007" or "Jan 06 2010 01:30PM". I haven't touched the second column yet (with the time still included), but I tried formatting the first in a different date format and that didn't work. Is there a way to format the first column as a date? I will probably just do a search and replace: "Jan" becomes "1", etc. then replace all the spaces with "/" - from there it should be an easy formatting issue. Not elegant, but solves the problem.
But what about the second column? I am at a loss as to how to delete the time when all of the times are different (I don't need the time - only the date). I think I could split text to columns (at the spaces) and then just delete the time, put the data back together with a Concatenate and format. Is there a better solution?
Any suggestions?
__________________
The thing about quotes on the internet is that you cannot verify their validity.- Abraham Lincoln
|