Excel Date Format - Display Correct Date without changing Regional Settings

[chrono2483]

Hello,

I pull regular raw data, and one of the columns is the date formatted as follows:

[TABLE="width: 148"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]01/08/2017 0:00[/TD]
[/TR]
[TR]
[TD="align: right"]02/08/2017 0:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/08/2017 0:00[/TD]
[/TR]
[TR]
[TD="align: right"]03/08/2017 0:00[/TD]
[/TR]
[TR]
[TD="align: right"]18/08/2017 0:00[/TD]
[/TR]
</tbody>[/TABLE]

Usually, I can use =int() to extract the date, and format it to display the true date (August 1, 2017; August 2, 2017; August 3, 2017, etc). However, with this file it all displays as August 1, 2017. No matter how I format the cell, I cannot get it to display the true date. When I convert to text, it all comes up as 42948.

Is there a macro/formula/formatting that can be done to convert it correct. I've read that it may have something to do with the regional settings, but I don't want to adjust the settings specifically for this one file.

Any help would be great. Thank you.

 

[MARK858]

Are you sure that the files calculation isn't set to manual?