convert general number to date format

[Jhon Mustofa]

hello all,

i have following data number as general format, like this below ;

2001
2008
2004
2003
1998
1997
etc,,..

how to make them with date format.....

31/12/2001
31/12/2008
31/12/2004
etc...

it's possible?

thanks!!

[alansidman]

Assume data is in column A. In column B =Date(A1, 12, 31) and copy down.

[azumi]

Maybe...

=VALUE(TEXT("31/12/"&2001,"DD/MM/YYYY"))

Is it all is date 31 and month 12 ?

[Jhon Mustofa]

Alan, azumi you are great....

thanks you very much....i am helped....

[Crisp Packet]

Or =("31/12/"&A1)+0

[Crisp Packet]

Error: Deleted post