SaturnusDJ
New Member
- Joined
- Dec 23, 2013
- Messages
- 7
While delimiting, I chose to import the date+time as text otherwise Excel does some kind of half converting.
But it does not get recognized as date.
What am I doing wrong?
Therefor I format the cell as: m/d/jjjj u:mm:ss AM/PMExample input 1: 9/1/2017 9:25:59 PM
Expected output: 01-09-2017 21:25:59 (or pc default)
Example input 2: 5/23/2017 7:56:17 AM
Expected output: 23-05-2017 07:56:17 (or pc default)
But it does not get recognized as date.
What am I doing wrong?
