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

How to change date format from dot to slash in excel
How to convert date from dot to slash format in excel - Best answers
Convert the date format in excel - Guide
How to convert date from dot to slash format in excel ✓ - Forum - Office Software
Converting date format in excel sheet ✓ - Forum - Excel
Unable to convert date format in excel ✓ - Forum - Excel
How to convert date format in excel from yyyymmdd to dd/mm/yyyy ✓ - Forum - Excel

1 reply

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")

Subscribe To Our Newsletter!