Forum Discussion
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 whateve...
Hello rbunkelman,
Excel doesn’t truly wrap long date formats — if the column is too narrow, it shows ####### because dates are stored as numbers. The workaround is to use a custom format with a line break (press Alt+Enter in the format string, e.g. dddd[Alt+Enter] mmmm d, yyyy) or a formula like =TEXT(A1,"dddd") & CHAR(10) & TEXT(A1,"mmmm d, yyyy") with Wrap Text turned on.
Both keep the cell dynamic, but the column still needs to be wide enough for the longest line.