Fixing Dates

Hi,

My dates are read in a wierd format as shown in column A. How can I convert this to the required format as shown in column B, in order for me to convert the column to Date/Time format.

A B
43191
43221
43252
43282
2018-04-01
2018-05-01
2018-06-01
2018-07-01

Thanks,

A newbie!

Most likely your data came from Excel. Then make sure it formatted as a date. If you read CSV then it has numeric presentation of Excel dates and needs to be fixed to present dates as text.