I have an excel file (10) with a column of date in format yyyy-mm-dd hh: mm: ss. I want to convert to the standard date/time format - that is mm-dd-yy hh: mm: ss.

Office

Question:Downloads have the system date is 2012-mm-dd hh: mm: ss General format. I need to convert to the format of date normal mm-dd-yy hh: mm: ss.Thank youAnswer:Select your cells and run this small macro:Sub ReFormat()Dim r As Range, v As StringFor each r in selectionv = r.Textyear = Left (v, 4)MN = Mid (v, 6, 2)dy = Mid (v, 9, 2)HR = Mid (v, 12, 2)Mint = Mid (v, 15, 2)SC = Right (v, 2)r.NumberFormat...Read More

Posted: 19 Feb 2012

Tags: I have an excel file 10 with a column of date in format yyyymmdd hh mm ss I want to convert to the standard datetime format that is mmddyy hh mm ss have excel file with column date format yyyymmdd want convert the standard datetime that mmddyy