=VALUE(TEXT(A2,"MMDD"))
On May 29, 9:05 am, Prabhu wrote:
> Hi Friends,
>
> I have change my cell which in the date format ex.MMDD or DDMM to
> original number i.e smiler to
> type date.I have attached the sheet in which Column A shows date format and
> Column B is what i need to conv
another variant
=DATE("20"&RIGHT(B2,2),MID(TEXT(B2,"00"),3,2),LEFT(TEXT(B2,"00"),2))
On Thu, May 12, 2011 at 8:58 PM, GoldenLance wrote:
> Use this in E2 and drag down
>
> =DATE(2000+RIGHT(B2,2),LEFT(RIGHT(B2,4),2),LEFT(B2,LEN(B2)-4))
>
> On May 12, 5:14 pm, Prabhu wrote:
> > Hi frien
Use this in E2 and drag down
=DATE(2000+RIGHT(B2,2),LEFT(RIGHT(B2,4),2),LEFT(B2,LEN(B2)-4))
On May 12, 5:14 pm, Prabhu wrote:
> Hi friends,
>
> Plz help to change date format when downloaded report from 1st of every
> month to 9th of the month will be like DMMYY .
>
> I have no issue in changing
