Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to convert date cells
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a macro to convert times between 2 places dep. on date? | Excel Worksheet Functions | |||
Macro to convert text to date | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Macro to convert date cells | Excel Programming |