Date/Time Formatting

is this a real date or text ?
if you click on the cell and format to general
does it change to a number

format as MM/DD/YYYY hh:mm am/pm

otherwise without adding a column and TEXT to columns doesn't change to a real date - may need vba, not my area
should be able to do with one additional column and function - if text

BUT
ote: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet.

A sample sheet would help here

The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Dec 4, 2022, 7:30:00 PM is text or is number?
You can check this with the function ISTEXT

you can probably use power query to change the date on import, and stay in column - dont know that yet, only just on my Mac
OR VBA

but i have used
=DATEVALUE(MID(A2,SEARCH(",",A2,1)-2,2)*1&"-"&LEFT(A2,3)&"-"&MID(A2,SEARCH(",",A2,1)+2,4))+TIMEVALUE(MID(A2,SEARCH(",",A2,1)+7,11))

and they maybe a better way using substitute or a shorter formula

but seems to work

only issue is its in a different column

When I opened your .csv (text) file into my spreadsheet using LO Calc, I specified that the date field should be imported as MDY dates, and Calc automatically recognized the date/times and stored them correctly as serial numbers. In my case, it automatically chose an "mm/dd/yy hh:mm AM" number format, but I could easily select whatever number format I want after the data are correctly imported.

Excel can do the same thing using the get data from text command and using the text import wizard. Or Power Query should have no trouble importing this text data into Excel. The key idea is to find an import strategy into the spreadsheet so that your spreadsheet application can readily recognize the date/time information and store it correctly.

my first use of power query, only found it had been added to my mac version yesterday - after a form question

so i just tried to use it
and it worked perfectly as suggested by MrShorty

also gave me a reason to try using it for real life reason ... thanks

would not work with import - and changing to MDY - not sure why - but tried that first before the formula

you are showing in your profile 2013 version - is that what you have ?

you need to update your profile from 2013 please - there are so many new functions that make solutions much easier - its important to know that