Unable to Change the date format [Closed]

Report
Posts
1
Registration date
Thursday June 1, 2017
Status
Member
Last seen
June 1, 2017
-
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
-
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

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
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