Forum Discussion
Excel Table Auto Formatting Issue
I have a table in my expenses spreadsheet. To add new rows, I type in the row below the last one in the table and it automatically adds it to the table range; my problem however, is that the new rows...
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.
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.