Previous Topic Next Topic

Help me convert a date format in Excel

Closed
marco1982 - Updated on Sep 14, 2018 at 05:16 AM
 Blocked Profile - Sep 14, 2018 at 05:00 PM
Hello,



I need to add the REPLACE, or anything else that convert a date inserted with dots into a date format with slashes, to a long IF formula. Please help
Related:

1 response

Answer 1 / 1
Blocked Profile
Updated on Sep 14, 2018 at 05:00 PM
Ok, so not really certain what you are sking, but it can be done with:

=Text(a1,"dd/MM/YYYY")

Similar discussions

How to change the language in MX player?
Vikashsingh -
ac3mark -

3 responses
How do you change aspect ratio using iMovie?
Danisdy -
Sanjeev9910 -

5 responses