Ctrl F
 

I am using the Ctrl F command to search through a 3,000 row
spreadsheet to locate a string of data. I am getting an error message
indicating "Microsoft Excel cannot locate the data you are search for"
However when I page through the data I find it in different cells.
What am I not doing.

Ctrl F
 

Select just one cell before issuing the Ctrl F command or select all of the cells.
If that is not the problem, post again with a sample of your search string

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message oups.com...
|I am using the Ctrl F command to search through a 3,000 row
| spreadsheet to locate a string of data. I am getting an error message
| indicating "Microsoft Excel cannot locate the data you are search for"
| However when I page through the data I find it in different cells.
| What am I not doing.
|

Ctrl F
 

On Apr 19, 6:31 pm, "Niek Otten" wrote:
Select just one cell before issuing the Ctrl F command or select all of the cells.
If that is not the problem, post again with a sample of your search string

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in ooglegroups.com...

|I am using the Ctrl F command to search through a 3,000 row
| spreadsheet to locate a string of data. I am getting an error message
| indicating "Microsoft Excel cannot locate the data you are search for"
| However when I page through the data I find it in different cells.
| What am I not doing.
|

This command works for about three attempts then I begin getting the
error message.

1281.50 is a sample of the data

Ctrl F
 

Is your 1281.50 a text string, or is it a number?

If the latter, then you may well not find it if you look for 128.50. If the
number is actually 128.5 then you will find it if your search for 128.5,
rather than for 128.50. If you search for 128.50 it will find 128.509 (even
it formatted to display as 128.51), but it will not find 128.5, nor will it
find 128.49999999 even if the latter is formatted with 2 decimals to display
as 128.50
--
David Biddulph

wrote in message
oups.com...

This command works for about three attempts then I begin getting the
error message.

1281.50 is a sample of the data

On Apr 19, 6:31 pm, "Niek Otten" wrote:
Select just one cell before issuing the Ctrl F command or select all of
the cells.
If that is not the problem, post again with a sample of your search
string

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in
ooglegroups.com...

|I am using the Ctrl F command to search through a 3,000 row
| spreadsheet to locate a string of data. I am getting an error message
| indicating "Microsoft Excel cannot locate the data you are search for"
| However when I page through the data I find it in different cells.
| What am I not doing.
|