=MID((TEXT(X7, "mmm/dd/yyyy hh:mm am/pm")),1,LEN((TEXT(X7, "mmm/dd/yyyy hh:mm am/pm")))-3)&" "&LOWER(RIGHT(TEXT(X7, "mmm/dd/yyyy hh:mm am/pm"),2)) for lowering am/pm
Thanks Anand. I got it to work, in so far as I can put the formula in a cell and have it return the correct date format in that cell.
Now the next challenge for me is to be able to use VBA to copy that formula into a cell. Not having luck so far.
After I can do that, the game plan is to copy down the formula (temporarily) as many rows as the dates are.
Then copy/paste special (values) back into the original date cells.
Then clear out the temp date formulae.
I'm thinking there must be an easier way just to change from AM to am?