If the date in cell A1 is in date format try the below

=TEXT(A1,"mmddyyyy")

but this will be text format.....

If this post helps click Yes
---------------
Jacob Skaria


"CyndiR" wrote:

What is the formula to change the date format from m/d/yyyy to mmddyyyy to
remove the dashes and have 2 digits for month, 2 digits for day and 4 digits
for year?

I tried left, mid and right formula but wasn't successful. I think the
commas and parenthesis weren't in the right place.

What is the CORRECT LEFT, MID, RIGHT formula?

From the example 10/8/1967, I tried just the left formula =LEFT(T2,2) and
the outcome was 24, not 10.

How do I fix this?

Thanks,
Cynthia