Ask a new question

How do I convert mmddyyyy to mm/dd/yyyy in excel 365?

How do I convert the date 03302020 to 03/30/2020 in excel 365? I have tried customizing the date to different formats. The date is originally typed in as text, example 03302020, that is March 30, 2020. I have tried resetting my settings date. It is not giving me the correct day. I get 03/03/2020 instead of 03/30/2020. I am using the formula =DATE(RIGHT(F2,4),MID(F2,2,1), LEFT(F2,2).

=DATE(RIGHT(F2,4),LEFT(F2,2),MID(F2,3,2))

Image

•Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi,

In cell B2, enter this formula

=TEXT(A2,"00\/00\/0000")

Image

Regards,

Ashish Mathur
www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thank you, This worked.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

You are welcome. You may also give feedback on it.

Image

•Beware of Scammers posting fake Support Numbers here.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated February 6, 2025 Views 1,488 Applies to: