How to find a cell with a particular date format?

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
Select that cell (just for testing).
Look at the formulabar--not what's displayed in the cell.

Use that when you try your Find.
 
Ctrl-F, click on the Options>> button, then the Format... button. Leave
search field empty to find all cells with that formatting.
 
Back
Top