How to find a cell with a particular date format?

[Tom]

Hi,

For example, I have a cell that shows the date as 08/11/07. How can I use
the Find command to locate it?

TIA
Tom

 

[Dave Peterson]

Select that cell (just for testing).
Look at the formulabar--not what's displayed in the cell.

Use that when you try your Find.

 

[Kaman]

Ctrl-F, click on the Options>> button, then the Format... button. Leave
search field empty to find all cells with that formatting.

 

[Tom]

Thanks Dave.

Select that cell (just for testing).
Look at the formulabar--not what's displayed in the cell.

Use that when you try your Find.