# Table date format change when select row

**URL:** <https://forum.inductiveautomation.com/t/table-date-format-change-when-select-row/55176>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [January 19, 2022, 5:19pm UTC](https://forum.inductiveautomation.com/t/table-date-format-change-when-select-row/55176 "2022-01-19T17:19:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [January 19, 2022, 5:19pm UTC](https://forum.inductiveautomation.com/t/table-date-format-change-when-select-row/55176/1 "2022-01-19T17:19:48Z")

</div>

Hi,

I’ve created a table with date format “DD/MM/YYYY” in first column.  
When I double-click in a cell to update it, format change to “MM/DD/YYYY”.  
It’s confusing for user.

Is it possible to change value format on cell editing ?

Thanks 🙂

---

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [March 31, 2022, 9:10am UTC](https://forum.inductiveautomation.com/t/table-date-format-change-when-select-row/55176/2 "2022-03-31T09:10:30Z")

</div>

Any solution for this problem ?  
Thanks
