convert date format
 

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

convert date format
 

On Sun, 26 Mar 2006 14:44:41 -0800, noel
wrote:

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

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

the same still


Your "date" is really TEXT. Formatting will not change the appearance of text.

Excel stores dates as serial numbers starting with 1 Jan 1900 (or 1904).

Let's gather more information to decide how to fix this.

How many dates are we talking about?
How did the date information get into the cell?
Will this be a repetitive task?
--ron