Report Date as MM/YY/DD | Community
Skip to main content
A
Anonymous
June 11, 2014
Solved

Report Date as MM/YY/DD

  • June 11, 2014
  • 4 replies
  • 1775 views
Can you export a report with a Date field formatted n MM/DD/YY or a similar date formating for easy sorting in Excel?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Justin_Cooperm2
It's actually just an issue with excel. You can fix it in two seconds:
  1. Select the entire column.
  2. Go to Data > Text to Columns.
  3. Choose "Fixed width."
  4. Remove all break lines.
  5. Set column data format to be the date format you want.
  6. Click "Finish."
  7. If you don't like the format still, you can now use the cell formatting options and it will work as expected.

4 replies

Justin_Cooperm2
Justin_Cooperm2
Level 10
June 11, 2014
You don't even need that, this can be done from Excel itself. Just right-click the cells and choose "Format Cells," then pick the formatting you'd like.
A
Anonymous
June 11, 2014
I can't figure out why that's not working on these reports I've exported. I have a Campaign Activity Report that will not allow me to format the Last Actvity values into date formats. I'm guessing because the values are General Text like Jan 15, 2014 09:00 AM.
A
Anonymous
June 11, 2014
I converted the Excel file that MKTO exports to a .CSV and the values auto-converted to MM/DD/YY HH:MM. This is the best solution.
Justin_Cooperm2
Justin_Cooperm2Accepted solution
Level 10
June 11, 2014
It's actually just an issue with excel. You can fix it in two seconds:
  1. Select the entire column.
  2. Go to Data > Text to Columns.
  3. Choose "Fixed width."
  4. Remove all break lines.
  5. Set column data format to be the date format you want.
  6. Click "Finish."
  7. If you don't like the format still, you can now use the cell formatting options and it will work as expected.
    Terms & ConditionsAccessibility statement

    Loading footer...