Time format not Registering

[LogMill1]

I have a date and time format as: 

27-APR-20 8.15.00.000000000 AM.

My problem is that PBI doesn't register this as a Date/Time field. Is there any formatting that I can do to remove the extensive 0's from the end of the time so PBI can register this as a date/time. Or any other recommendations on how to get PBI to register this as a date/time field? Thank you in advance for any help!

[HotChilli · Accepted solution]

Import it as text and replace .000000000 AM.  with AM  (use the Replace Value from the column header in the interface.)

Then change it to date/time.