I have an excel document that is being used for reports. For readability I currently have all the columns fairly narrow and am using cell overflow a lot visually. I want excel to recognize numbers and dates as such, I just want them to visually overflow like text does.
-Non technical users will need to make versions off this document for their own reports
-this document will be passed around as a report in excel format
I've added an image of the section that's a problem here to clarify the problem a little. You'll notice how H is shortening the date, it contains information almost identical to M. M will do so once I click out of the cell. I want it to display like J50 or H51, both of which are flowing out beautifully.