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

Copy the files from the WP7 phones

» Windows Phone

Question:How can I copy / transfer files from my PC to the WP7 phone (.5)?I have the need from time to time, take files with me (for example to search for information in meetings);But how can I copy the files to the phone?Basically, I would like to connect the phone via the USB port of the computer and then copy the files via Windows Explorer (would be the simplest way) as it was possible even with...Read More

Posted: 19 Feb 2012

Tags: Copy the files from the WP7 phones Copy the files from WP7 phones

Have a message appears when the registration and closing of a file?

Office

Question:Assistance. New VBA and you all is an excellent resource, with my Excel VBA for Dummies book. Is it possible to write code that would make a message appear in Excel when save them and close a file? Not one "either / or"scenario;"" only when do both.Answer:Assistance. New VBA and you all is an excellent resource, with my Excel VBA for Dummies book. Is it possible to write code that would make...Read More

Posted: 17 Feb 2012

Tags: Have a message appears when the registration and closing of a file Have message appears when the registration and closing file

I continue to a message asking me "Do you open or save" a file after I click to open it. How get rid me of the message?

» Windows

Question:Message is the basis of my screenAnswer:aI assume that you receive this message when you use a link to download the elements in Internet Explorer.If I am Correct, then this is perfectly normal and I see nothing concerning here. The option open the file downloads the file in temp folder all save as option downloads the file to the folder defined by the user.Read More

Posted: 17 Feb 2012

Tags: I continue to a message asking me Do you open or save a file after I click to open it How get rid me of the message continue message asking you open save file after click How get rid the

The steps for transfer music from the iPod to your PC without changing file names

Gadget

Being an avid music lover, you can have stored music on your iPod or your iPhone so that you can enjoy the whenever you feel like. It is irritating sometimes when you try to copy songs from your device to your PC and not being able to do so successfully. However, there are several ways to do it manually, but it could be either the name of the file unreadable formatting or it can compel you to change...Read More

Posted: 17 Feb 2012

Tags: The steps for transfer music from the iPod to your PC without changing file names The steps for transfer music from the iPod your without changing file names