The reason you get 24 from your LEFT formula is that 10/8/1967 is
represented as 24753 (the number of days from the start of 1900).
You'd need to use TEXT(T2,"mmddyyyy") as others have suggested.
--
David Biddulph

"CyndiR" wrote in message
...
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