=VALUE(TEXT(A2,MMDD))
On May 29, 9:05 am, Prabhu prabhugate...@gmail.com 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
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 prabhugate...@gmail.com 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
another variant
=DATE(20RIGHT(B2,2),MID(TEXT(B2,00),3,2),LEFT(TEXT(B2,00),2))
On Thu, May 12, 2011 at 8:58 PM, GoldenLance samde...@gmail.com 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