Macro to convert date cells
 

I need to take a range of cells and convert the values of them into a
different date format. Currently the cells are in the form mm/dd/yyyy
h:mm:ss AM/PM. I need the cell to contain the value of mm/dd/yy
h24:mm. I can't just do a cell format because that doesn't change the
actual values in the cell. I think maybe I need to copy the values to
notepad (or likewise), reformat the cells to text, and then paste the
data back into excel. Anyone have any idea how to do this? Or if you
know a better way, I am all ears!!

Any input would be greatly appreciated, this is driving me crazy!

Brian


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/