Thanks for the reply.
A neat little brutal way to foce excel to do my bidding, but I'm not sure if it will work out well with my project because I do not really know which data will be "Date-like" and which will be normal. (I'm pulling this all from an access database created by a separate program.) I could add a single quote to all my non-numeric data (Which basically resides in a certain column), but that doesn't seem an ideal solution for a large excel sheet just because of a single possible co-incidence.
I was thinking I could try to query for the format in advance, then if it is a date format then add that approach, but that won't work because, like I mentioned, as soon as the data is converted to a "Date" the actual value of the data becomes ruined.
Thanks a lot for the response; I'm doubting that there's any other solution to this irksome problem, but one can always hope. Wishing there was a property .disableannoyingassumptions = false,
Video Tutorials / Excel Dashboards Reports