Forum Discussion
Excel Table Auto Formatting Issue
Dear NikolinoDE You wrote "any new rows you add to the table will INHERIT the formatting of that style" -what if it DOES NOT INHERIT formatting o the table column? Have no idea, it happens only in columns with date format, whole column has standard date short format, and newly added row in that cell(column) unexpectedly changes to "non-standard". Have anyone met such akwardness?
Date in new row shall be added in full date format recognized in your environment, e.g. 2023-09-15. When to it automatically will be applied default column format. If column format is like mm yy or like and you enter new date as 09 23 above will be recognized as text or converted to wrong date, depends on your regional settings. Above is just a sample, it could be any other format.
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.