# Several entires switched to MM/DD/YYYY upon import

**URL:** <https://community.tiller.com/t/several-entires-switched-to-mm-dd-yyyy-upon-import/7775>\
**Category:** Google Sheets\
**Tags:** troubleshooting\
**Created:** [February 21, 2021, 10:01pm UTC](https://community.tiller.com/t/several-entires-switched-to-mm-dd-yyyy-upon-import/7775 "2021-02-21T22:01:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![galatic\_incipient](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/galatic_incipient/32/1522_2.png) [@galatic\_incipient](https://community.tiller.com/u/galatic_incipient)\
**Post date:** [February 21, 2021, 10:01pm UTC](https://community.tiller.com/t/several-entires-switched-to-mm-dd-yyyy-upon-import/7775/1 "2021-02-21T22:01:49Z")

</div>

Hey there,

I have 55 entries that were imported into my transactions list showing the incorrect date (list below). The day and month are switched, so 2/5/2021 shows as 5/2/2021. All of my other thousands of transactions are in the proper DD/MM/YYYY format.

How can I fix these aside from manually switching the day and month, and does anyone know why it happened (will it happen again)?

Thanks!

```
12/2/2021
12/2/2021
12/1/2021
12/1/2021
11/2/2021
11/2/2021
11/2/2021
11/1/2021
10/2/2021
10/2/2021
10/2/2021
10/1/2021
10/1/2021
9/2/2021
9/2/2021
9/2/2021
9/2/2021
9/2/2021
9/2/2021
```

---

<div class="post-metadata">

**Author:** ![aronos](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/aronos/32/4354_2.png) [@aronos](https://community.tiller.com/u/aronos)\
**Post date:** [February 21, 2021, 10:49pm UTC](https://community.tiller.com/t/several-entires-switched-to-mm-dd-yyyy-upon-import/7775/2 "2021-02-21T22:49:58Z")

</div>

I’ve had that happen from time to time. Not sure why but it’s simple enough to get things back in order.

Click on the top of the column above where it says “Date” and it should highlight the entire column. Then click the Format Menu, then Number, and select the appropriate date format.

---

<div class="post-metadata">

**Author:** ![galatic\_incipient](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/galatic_incipient/32/1522_2.png) [@galatic\_incipient](https://community.tiller.com/u/galatic_incipient)\
**Post date:** [February 21, 2021, 11:32pm UTC](https://community.tiller.com/t/several-entires-switched-to-mm-dd-yyyy-upon-import/7775/3 "2021-02-21T23:32:05Z")

</div>

Thanks for your reply.

I did this, but unfortunately it thinks the text is showing MM/DD, so all the format options are just variations of this. None would let me swap the day and month around. I think I may have to fix this manually and hope it doesn’t keep happening!

Edit: I ended up fixing this manually by pasting the following in an empty column, and coping it over the dates: =mid(B137,3,2)&left(B137,2)&“21” where B137 is the date cell.

---

<div class="post-metadata">

**Author:** ![aronos](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/aronos/32/4354_2.png) [@aronos](https://community.tiller.com/u/aronos)\
**Post date:** [February 22, 2021, 7:01am UTC](https://community.tiller.com/t/several-entires-switched-to-mm-dd-yyyy-upon-import/7775/4 "2021-02-22T07:01:02Z")

</div>

Not sure why you wouldn’t have the default formats, but you can go to the bottom of that “Number” menu to “More Formats” and create any format you could possibly imagine