How do I replace all instances of dates with an X?

[dijilator]

I have a spreadsheet with column headers of Skills and row headers of Employees. Where an employee is trained on a given skill, the cell has the training date. All this data is exported from Access. This spreadsheet just needs the fact that they were trained in a given skill, not the training date. To conserve space, I want to change all the training dates to an X and narrow the columns. How would I make a search for all the dates and replace them with an X?

This is in Excel 2007.

 

[dijilator]

Splendid! Thanks, JoeMo!

 

[dijilator]

That worked as well! Thanks!