Long Date Format Text Wrapping

I need my dates to be in the long date format: Monday, December 8, 2025

However, I also want that text to wrap.

I do not want an really wide column for that date. I would like it to wrap at whatever point it wrap at when I adjust the column width.

Simply choosing "wrap text" in the alignment section does not work. Any column width shorter than the amount of space needed for the entire date turns the date in that cell to pound signs. Heck, I'd be happy if I could even just shorten the column width and see only the beginning of the date. Though I would prefer it just adjusting like it does in every other column.

I have tried work arounds like a custom date format where you force the second line to be part of the date - which it will do but the column width still must be as long as if it were in one long line or it still goes to pound signs.

Is there a workaround that I can't find? Is this something that Microsoft could work on fixing in an upcoming app update? Because I have been suffering through this problem for years and would love for it to be fixed.

(Also - I do not want to change the column to "text" - I want to be able to type in 12/9 and have it automatically change to Tuesday, December 9, 2025 for me. I am often changing dates or inserting dates and need it to be dynamic and not manually entered each time. (Thus the whole point of having the date format to begin with.)