Forum Discussion
Re: Excel Table Auto Formatting Issue
SergeiBaklan it doesn't work as expected. I add a new row, cell in column with my dates is empty, but format is already changed from my system settings dd.mm.yyyy to m.d.yyyy. Worse, change in table date format occurs when I use PowerQuery. Frustrating.
2 Replies
Sorry, I didn't catch why Power Query is here. Let assume we have the table
To entire column are applied formats as above, i.e. date as yyyy mm dd and both Date and Text are centered.
Now I add some date in my regional format which will be recognized as date, not text, and text to the right column
To the new row are applied column formats
- Dear Sergei, The PQ query result is usually a table, so I mentioned. But my situation with simple table - it doesn't matter what/how I write in cell date, because format in cell is changed directly after adding a new row. Cell in a new row doesn't inherit format from whole unity column format. Anyway, thank you.
