Unable to Change the date format

Closed
masura76 Posts 1 Registration date Thursday June 1, 2017 Status Member Last seen June 1, 2017 - Jun 1, 2017 at 11:33 PM
Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 - Jun 2, 2017 at 02:54 PM
Hello,

I need to change the date format from Apr 2, 2017 01:39 PM to dd/mm/yyyy hh:mm but still not successful.

Kindy assist.



1 reply

Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 146
Jun 2, 2017 at 02:54 PM
masura76, Good afternoon.

Are you sure that the cell contains a real date?

Do a test:
Suppose A1 has your date.

B1 --> =ISNUMBER(A1)

Is the result TRUE or FALSE
0