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 | ||||||||
---|---|---|---|---|---|---|---|---|---|
|
|
Thanks,
A newbie!
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 | ||||||||
---|---|---|---|---|---|---|---|---|---|
|
|
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.