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

dates of default value is yyyy-mm-dd

Office

I want that my default date format is yyyy-mm-dd. How can I get that? |Edit and save the default excel templatehttp://Office.Microsoft.com/en-us/Excel-help/customize-how-Excel-starts-HP005199391.aspxUnless you want to say the victory of thought, and then change victory of the Date/time settingsRead More

Posted: 07 Feb 2012

Tags: dates of default value is yyyymmdd dates default value yyyymmdd