Forum Discussion
Change date text formatted as dd/mm/yyyy hh:mm:ss AM/PM into date serial no.
I have raw cvs file dump with text strings I need to return in a new column with the date/excel "serial number": the cell contains for example: "23/07/2019 12:12:11 PM" I need to return a serial da...
Wa…..Fantastic. You have no idea how helpful that was.
Hi,
Having real issues in converting a date in excel. It was so easy with google sheets.
Can anyone lend me a hand? (check attachment)
- Your formula doesn't even refer to the column in which the date appears. That could be the cause of it not working.
If you still have difficulties, though, please attach a copy of the spreadsheet, or a portion of it. Images aren't all that helpful when you're seeking help.- Thanks for your reply. I managed to solve it differently
