troubleshooting Question

Output to Excel Formats Dates Incorrectly

Avatar of djw8
djw8 asked on
Microsoft Excel
6 Comments1 Solution179 ViewsLast Modified:
I am running a proprietary Access application that outputs data to Excel for Analysis. I need to do some basic date computatations but I can't because I can't properly format the dates in Excel. I've tried several solutions without success. I've highlighted the column, right clicked it then tried to format it as a date, I've used the text to number, then tried to format as a date. That produced ########### characters which I understand is an undersized cell indication but I couldn't seem to make the cell large enough to show me the date. Is there a setting I can use that will make the date issue a little easier to manage? Thanks
ASKER CERTIFIED SOLUTION
NorieSenior Associate
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros