Try this: insert column and add this formula (copy down for all dates);

=MONTH(A1) & "/" & DAY(A1) & "/" & YEAR(A1)

Change A1 to suit.

If OK, for new column do Copy/PasteSpecial/Values to convert formulae to
values and then delete original column.

HTH

"noel" wrote:

date is now in mm/dd/yy (general format)

after switching cell format to dd/mm/yy (date format)

the same still

"Toppers" wrote:

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