You can just highlight all the cells you want to change (these can
include text values as these won't be affected) and then just Format |
Cells | Number tab and choose the date format you require.

Hope this helps.

Pete

On Nov 6, 10:06 pm, Bob W wrote:
I inherited a spreadsheet with 2,285 rows; each row has dates typed into
them, and the dates are in three random formats, ie,

5-Aug-05
12/27/97
3-12-04

Is there a way, other than manually, to correct all the dates to one uniform
date format?