# Export Excel date is shortened

**URL:** <https://forum.inductiveautomation.com/t/export-excel-date-is-shortened/42175>\
**Category:** Ignition\
**Created:** [January 12, 2021, 8:03pm UTC](https://forum.inductiveautomation.com/t/export-excel-date-is-shortened/42175 "2021-01-12T20:03:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![DD\_Chelsea](https://avatars.discourse-cdn.com/v4/letter/d/b9e5f3/32.png) [@DD\_Chelsea](https://forum.inductiveautomation.com/u/DD_Chelsea)\
**Post date:** [January 12, 2021, 8:03pm UTC](https://forum.inductiveautomation.com/t/export-excel-date-is-shortened/42175/1 "2021-01-12T20:03:55Z")

</div>

Hello! good afternoon.

Could you help me to see why the date is being shortened when i export it to excel.

Here is the table with the full date

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/8/8884a315b4bb98300e45f312a0b64c22b31bfd29.png)

but when i export it it appears like this:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/2/327c7e36db93c2f051e3ceee67faa42e829ef07b.png)

Do you know why is happening this?

Thanks in advance for the help!

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [January 12, 2021, 8:04pm UTC](https://forum.inductiveautomation.com/t/export-excel-date-is-shortened/42175/2 "2021-01-12T20:04:58Z")

</div>

Have you checked what format you’re using to display the date columns in Excel? It’s probably set to just show the date

---

<div class="post-metadata">

**Author:** ![DD\_Chelsea](https://avatars.discourse-cdn.com/v4/letter/d/b9e5f3/32.png) [@DD\_Chelsea](https://forum.inductiveautomation.com/u/DD_Chelsea)\
**Post date:** [January 12, 2021, 8:10pm UTC](https://forum.inductiveautomation.com/t/export-excel-date-is-shortened/42175/3 "2021-01-12T20:10:33Z")

</div>

thanks for the response!

is there a way to show the date and time in the excel file?

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [January 12, 2021, 8:15pm UTC](https://forum.inductiveautomation.com/t/export-excel-date-is-shortened/42175/4 "2021-01-12T20:15:32Z")

</div>

Yes, you need to use a custom format. It’s a bit stupid that they don’t give you a datetime option 😕

---

<div class="post-metadata">

**Author:** ![DD\_Chelsea](https://avatars.discourse-cdn.com/v4/letter/d/b9e5f3/32.png) [@DD\_Chelsea](https://forum.inductiveautomation.com/u/DD_Chelsea)\
**Post date:** [January 12, 2021, 8:17pm UTC](https://forum.inductiveautomation.com/t/export-excel-date-is-shortened/42175/5 "2021-01-12T20:17:32Z")

</div>

Thanks for the help!

problem solved 🙂

Have a good day!