Column A | Column B |
08/07/2019 12:00 AM | 01/00/1900 7:03 AM |
<tbody>
</tbody>
Here is what the original looks like
08/07/2019 7:03 PM
The table above is what text to columns gives. When I format Col A to Date, short date that column is fine. When I format Col B to Custom h:mm AM/PM, it gets the AM or PM incorrect, randomly it seems. For example, in the table above, it should have been 7:03 PM instead of AM
Is there a way to fix this without VBA code? TY