asked on

Excel formula to change 7/17/2013 to this format 121210 mmddyy

Hi

I have Windows Excel 2010.

I have a column with dates like this:

07/17/13
07/17/13
07/17/13
07/17/13

and I want to change them to this format
mmddyy

I don't see that in the formatting options.

Can you provide a formula to do that?

Thanks
Rowby

SOLUTION

Naresh Patel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Norie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

NBVC

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rowby Goren

ASKER

HI itjockey

Thanks for helping. I guess I may have entered the formula wrong.

Please see See attached.

Thanks

Rowby
expoerts-exchange.xlsx

Rowby Goren

ASKER

HI :NBVC2

I missed your suggestion. Will test that too.

Rowby

Norie

Both suggestions I made should work for you, see the attached file.
expoerts-exchange.xlsx

Rowby Goren

ASKER

Thanks all.

I ended up using the custom format. But all suggestions are helpful!

Hope I splitted the points fairly. That is sometimes the hardest part here !

Rowby

NBVC

Hi Rowby,

Thank you for the point split.

Don't worry about it here, but for the future FYI, there are also statistics for "Answered" vs. "Assisted" solutions as defined by the thread starter (you). So if you say you used the Custom Format reply as your solution, then you should define that one as the "Accepted" and all other that you deem assisted as "Assisted".

Cheers.

Rowby Goren

ASKER

Ah, NBVC!

Thanks for that info. I will use it in the future.

Rowby

Naresh Patel

Mr.imnorie,

I had tried your solution before you posted ....in my lumia phone but I don't know why it show error message so I had leave that..... :):):)

Naresh Patel

Mr.Rowby,
I am not here for points.....learning....:):):)

Norie

I'm confused, I though I suggested using Custom format?

Naresh Patel

I.e. =TEXT(A1,"mmddyy")

Thanks