Highlight all the cells you wish to format. Go into your format pulldown and
select "Cells". Click the date option and choose the format you want.

"oceanmist" wrote:

I need to sort on a date column but cannot do it so that it makes any sense
as the date column is formatted as, for example -

20.08.07

for August 20, 2007

I need to make turn the periods into /'s so that it recognizes its a date.
How do I do this?