software

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

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

the same still

quot;Toppersquot; wrote:

gt; You say it doesn't work - what results do you get?
gt;
gt; Format==gt;Cells==gt;Date==gt;14/03/01
gt;
gt; gives date in dd/mm/yy format
gt;
gt; XL2003 (and UK-based!)
gt;
gt; quot;noelquot; wrote:
gt;
gt; gt; i am using microsoft office 2003.
gt; gt; currently i need to columns of data (in general format) to date (DD/MM/YY)
gt; gt; format.
gt; gt; tried clicking Format=gt;Cells=gt;Number=gt;Date (select date type) it doesnt work.
gt; gt;
gt; gt; please advise alternate method thanks.
gt; gt;
gt; gt; regards
gt; gt; noel

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

=MONTH(A1) amp; quot;/quot; amp; DAY(A1) amp; quot;/quot; amp; 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

quot;noelquot; wrote:

gt; date is now in mm/dd/yy (general format)
gt;
gt; after switching cell format to dd/mm/yy (date format)
gt;
gt; the same still
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; You say it doesn't work - what results do you get?
gt; gt;
gt; gt; Format==gt;Cells==gt;Date==gt;14/03/01
gt; gt;
gt; gt; gives date in dd/mm/yy format
gt; gt;
gt; gt; XL2003 (and UK-based!)
gt; gt;
gt; gt; quot;noelquot; wrote:
gt; gt;
gt; gt; gt; i am using microsoft office 2003.
gt; gt; gt; currently i need to columns of data (in general format) to date (DD/MM/YY)
gt; gt; gt; format.
gt; gt; gt; tried clicking Format=gt;Cells=gt;Number=gt;Date (select date type) it doesnt work.
gt; gt; gt;
gt; gt; gt; please advise alternate method thanks.
gt; gt; gt;
gt; gt; gt; regards
gt; gt; gt; noel