Forum Discussion
Long Date Format Text Wrapping
This didn't work in the web-based version for me. But I have an easy work around that is more flexible. Make it two rows, with the second row auto copying the values of the first row. Then set the number format of each row to what you need it to be. For Example: If the top row has the number format as "dddd" it will show the date simply as the name of the day (Sunday, Monday, etc) then if the second row has the number format as "mmm/dd/yyyy" it will show Oct/10/2026 or whatever. Now the trick, each lower cell should auto copy the value of each upper cell. So if your first upper cell is b1 , then in cell b2 you type "=b1" then in cell c2 you type "=c1" , etc. The flexibility of it comes in the ability to have different fonts sizes and bold your days.