Menu
Ask a question Report

Help me convert a date format in Excel

-
Excel Ask a question Report
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
See more 

Your reply

Reply to this topic

1 reply

Report Respond to ac3mark
Posts
11355
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
February 16, 2019
 2118
0
Thank you
Ok, so not really certain what you are sking, but it can be done with:

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

Respond to ac3mark

Your reply

Reply to this topic
Ask a question