Title: Custom Date Format Code – Excel
Last modified: September 1, 2020

---

# Custom Date Format Code – Excel

 *  [boabo](https://wordpress.org/support/users/boabo/)
 * (@boabo)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/custom-date-format-code-excel/)
 * Hi,
    Once i export to excel (version 1.8.1), submit_date format is set as “general”
   by default so i cannot remove minutes/seconds and change for example 2020-09-
   01 06:50:30 to yyyy-mm-dd using a custom date format code. Thank you
 * tested with OpenOffice and MS Excel 2007
    -  This topic was modified 5 years, 9 months ago by [boabo](https://wordpress.org/support/users/boabo/).
    -  This topic was modified 5 years, 9 months ago by [boabo](https://wordpress.org/support/users/boabo/).

Viewing 1 replies (of 1 total)

 *  Thread Starter [boabo](https://wordpress.org/support/users/boabo/)
 * (@boabo)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/custom-date-format-code-excel/#post-13343999)
 * solved [https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0](https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0)
   but it’s a long process 🙂

Viewing 1 replies (of 1 total)

The topic ‘Custom Date Format Code – Excel’ is closed to new replies.

 * ![](https://ps.w.org/advanced-cf7-db/assets/icon-256x256.jpg?rev=1696186)
 * [Advanced Contact form 7 DB](https://wordpress.org/plugins/advanced-cf7-db/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/advanced-cf7-db/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/advanced-cf7-db/)
 * [Active Topics](https://wordpress.org/support/plugin/advanced-cf7-db/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/advanced-cf7-db/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/advanced-cf7-db/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [boabo](https://wordpress.org/support/users/boabo/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/custom-date-format-code-excel/#post-13343999)
 * Status: not resolved