FIND and dates

M

Molly

I have several large spreadsheets in 2007, each containing many columns of
numbers, dates, and text. When I hit CTRL F and type either a number or text
in the box, it's found immediately. When I try dates, "...cannot find the
data..." pops up.

Date is currently formatted as 30-Jun-08. What do I need to do to make
dates able to be found (short of changing the date presentation on the sheet)?

Thanks!
 
S

Spiky

I have several large spreadsheets in 2007, each containing many columns of
numbers, dates, and text. When I hit CTRL F and type either a number or text
in the box, it's found immediately. When I try dates, "...cannot find the
data..." pops up.

Date is currently formatted as 30-Jun-08. What do I need to do to make
dates able to be found (short of changing the date presentation on the sheet)?

Thanks!
Click to expand...

You have to change the Options in the Find dialog box to Look In
"Values" to find dates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup with Dates 0
To Calculate the qty b/w two dates 6
Excel Macro to automatically go to the right of the last colored cell 0
Formatting cells to show two dates in one cell 3
how can i networkdays date ranges where dates overlap 1
using dates for lookup 2
Custom auto filter (Dates) 2
dates and text in excel 2

Top