Hi!

Select the range of cells in question.

Goto DataText to Columns
Click NEXT twice
Select Column Data Format: DATE. Then choose the format from the drop down
Finish

Biff

"Frank Winston" wrote in message
...
Is there a way to convert a column of text, date values (entered as 81096,
for example) to valid date format, 8/10/96? I could not get the DATEVALUE
function to do this.