G
GLH
Using Excel 2003. Excel cannot find match for data that exists in
spreadsheet when using the Find command. Any fixes?
spreadsheet when using the Find command. Any fixes?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
Perhaps Excel cannot find a match and doesn't need fixing.
Your data may need fixing.
Do you have extra spaces in the data?
Are you looking for "entire cell contents"
Are you looking for an exact match as in case-sensitive?
Are you looking in formulas when you should be looking in values?
See the available options under Edit>Find "Options>>" button.
Gord Dibben Excel MVP
Your data may need fixing.
Do you have extra spaces in the data?
Are you looking for "entire cell contents"
Are you looking for an exact match as in case-sensitive?
Are you looking in formulas when you should be looking in values?
See the available options under Edit>Find "Options>>" button.
Gord Dibben Excel MVP
G
Guest
cells are highlighted, it will only search in those cells)-----Original Message-----
Using Excel 2003. Excel cannot find match for data that exists in
spreadsheet when using the Find command. Any fixes?
make sure the curser is on one cell only (if multiple
G
GLH
The answer to all of the following questions is "no." I'm selecting only
one cell in the spreadsheet is searching for a number. For example:
294.10. The number exists in a list of numbers in the spreadsheet but Excel
2004 does not find it. I get a message "Microsoft Office Excel cannot find
the data you are searching for." This problem recurs over and over for
various numbers in multiple spreadsheets.
one cell in the spreadsheet is searching for a number. For example:
294.10. The number exists in a list of numbers in the spreadsheet but Excel
2004 does not find it. I get a message "Microsoft Office Excel cannot find
the data you are searching for." This problem recurs over and over for
various numbers in multiple spreadsheets.
G
GLH
Correction to clairify my response:
The answer to all of the following questions is "no." I'm selecting only
one cell in the spreadsheet and I am searching for a number. For example:
294.10. The number exists in a single cell without any specail formattting
but Excel 2003 does not find it. I get a message "Microsoft Office Excel
cannot find
the data you are searching for." This problem recurs over and over for
various numbers in multiple spreadsheets.
The answer to all of the following questions is "no." I'm selecting only
one cell in the spreadsheet and I am searching for a number. For example:
294.10. The number exists in a single cell without any specail formattting
but Excel 2003 does not find it. I get a message "Microsoft Office Excel
cannot find
the data you are searching for." This problem recurs over and over for
various numbers in multiple spreadsheets.
D
Dave Peterson
My guess.
You have a value of 294.1 in the cell--but it's formatted to show 294.10.
Try searching for the value--not what's displayed.
You have a value of 294.1 in the cell--but it's formatted to show 294.10.
Try searching for the value--not what's displayed.
G
GLH
Hmm. Great suggestion. I think this may have solved the mystery. Thank
you very much.
you very much.
D
Dave Peterson
Watchout for 24.099999 in the cell, too.
That could cause heartache and grief.
That could cause heartache and grief.
G
Gord Dibben
Open a new blank workbook.
Enter 294.10
Edit>Find
Set Options to "Sheet" "Values"
Can Excel find that?
Gord Dibben Excel MVP
Enter 294.10
Edit>Find
Set Options to "Sheet" "Values"
Can Excel find that?
Gord Dibben Excel MVP
D
Dave Peterson
Hey, that worked, too!
Well, if I formatted the cell to show 2 decimals.
Well, if I formatted the cell to show 2 decimals.
G
Gord Dibben
GLH
You answered NO to this when asked earlier.
In any case, glad you're sorted out.
Gord Dibben Excel MVP
Are you looking in formulas when you should be looking in values?
You answered NO to this when asked earlier.
In any case, glad you're sorted out.
Gord Dibben Excel MVP
Hmm. Great suggestion. I think this may have solved the mystery. Thank
you very much.