Date Format

[satyamsaurabh]

I have a date in 'MMYY format, i want to convert it in to 'YYYYMM format.

I tried =TEXT(A1,"YYYYMM"), but didnt get the desired result
Here is what i got:

MMYY YYYYMM
0104 190004
0104 190004
0105 190004
0105 190004
0203 190007
0205 190007

I want the following result instead

0104 200401
0104 200401
0105 200501
0105 200501
0203 200302
0205 200502

Any help greatly appreciated.

Thanks

 

[Norie]

Are the values in the first column actually dates?

They don't appear to be.

 

[satyamsaurabh]

The first column is a Download from SAP, It got downloaded in MMYY format, i want to convert MMYY to YYYYMM

Thanks

 

[fairwinds]

Hi,

Try:

=20&RIGHT(A1,2)&LEFT(A1,2)

This gives a text string and not a true date value.

 

[satyamsaurabh]

Thank you so much, It works just fine