You say it doesn't work - what results do you get?

Format==Cells==Date==14/03/01

gives date in dd/mm/yy format

XL2003 (and UK-based!)

"noel" wrote:

i am using microsoft office 2003.
currently i need to columns of data (in general format) to date (DD/MM/YY)
format.
tried clicking Format=Cells=Number=Date (select date type) it doesnt work.

please advise alternate method thanks.

regards
noel