Help me convert a date format in Excel Closed

Question

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

ac3mark · Answer

Ok, so not really certain what you are sking, but it can be done with:

=Text(a1,"dd/MM/YYYY")

Help me convert a date format in Excel

1 response

Similar discussions

Subscribe To Our Newsletter!