I'm bringing in data from a Access Database to Excel and it come in a table. One column is a date field, the problem is that the date is showing up as text rather than a date. So it will look like a date but it doesn't have the formatting to go with it. If I go edit the information it comes out as a date. The problem to that solution is that the content gets updated every time the file is open and reverts the data back to text.
I"m sure that this issue has been addressed some where, and any help would be greatly welcomed.
Bookmarks