date

[soumyajit]

A B C D

01/01/2001 01 01 2001

07/02/2011 07 02 2011

28/09/2007 28 09 2007


Is it possiable,plz help me.

 

[sdsurzh]

Hi,


Assume your data in A1 and paste the following formula in B1 =TEXT(A1,"MM DD YYYY")


Thanks,

Suresh Kumar S

 

[oldchippy]

Hi soumyajit,


May be this will work for you?


=DATEVALUE(A1&B1&C1) format the cell to DATE


Also please read this post from Hui...


http://chandoo.org/forums/topic/please-read

 

[Kevin@Radstock]

Hi


In:

B1: =DAY(A1)

C1: =MONTH(A1)

D1: =YEAR(A1)


Copy down and format to show preceding zero's if required.

 

[Debraj]

Hi Soumyajit..


Thank you for posting QUESTION... and I think you don't bother about answer.. whether they are right or wrong.. You just need to submit question.. Happy QUESTIONING ..


http://chandoo.org/forums/topic/text

http://chandoo.org/forums/topic/figer-out

http://chandoo.org/forums/topic/help-7

http://chandoo.org/forums/topic/help-me

http://chandoo.org/forums/topic/plz-help-me

http://chandoo.org/forums/topic/late-fine-calculation

http://chandoo.org/forums/topic/value-only-formula

http://chandoo.org/forums/topic/over-write-or-over-paste

http://chandoo.org/forums/topic/help-4

http://chandoo.org/forums/topic/vlookup-10

http://chandoo.org/forums/topic/help-3

http://chandoo.org/forums/topic/date-3


Regards,

Deb

 

[aparvez007]

Astonishing work Deb...


Regards,

Pavi