That solution isn't working for my data. Perhaps I should have mentioned that other data points in my sheet are numerical format. The original formula works well for those.

As an example, "12/9/2013 11:59:00 PM", right aligned. Applying text to data columns results in the date plus 12:00:00, but the formula works in that instance?

I hope this helps..let me know if I need to clarify and I'll upload.