chrono2483
Board Regular
- Joined
- Aug 23, 2014
- Messages
- 164
- Office Version
- 2016
Hello,
I pull regular raw data, and one of the columns is the date formatted as follows:
<colgroup><col></colgroup><tbody>
</tbody>
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.
I pull regular raw data, and one of the columns is the date formatted as follows:
| 01/08/2017 0:00 |
| 02/08/2017 0:00 |
| 03/08/2017 0:00 |
| 03/08/2017 0:00 |
| 18/08/2017 0:00 |
<colgroup><col></colgroup><tbody>
</tbody>
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.
