 ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 1481 guests online.
New Excel Experts
Current Excel / VBA Jobs |
convert ddmmyy to mmddyyI wish to convert date from ddmmyy in the text format to mmddyy in the date format. Please tell me the formula to convert it in the mmddyy date format. |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
it depends on how the date is
it depends on how the date is stored...
if it's stored as a date, then simply reformat the cell as "mmddyy"
if it's stored as a number, and in cell A1, you need to use
=MID(A1,2,2)&LEFT(A1,2)&RIGHT(A1,2)
If it's an American date that has been imported into Excel, and Excel has converted incorrectly into a European date, have a look here:
http://excelexperts.com/Excel-Tips-American-date-to-proper-date