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/

Select the column. format with the format that you want. Now do Data=Text
to columns, select delimited and use TAB as the delimiter in the second
dialog and then click finished.

This should cause your values to be interpreted as dates. Suspect they are
being treated as Text right now.

--
Regards,
Tom Ogilvy


"bslater" wrote in message
...

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/