Re: Ctrl F

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

<ltstrong@xxxxxxxxxxx> wrote in message
news:1177023654.573700.199640@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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" <nicol...@xxxxxxxxx> 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

<ltstr...@xxxxxxxxxxx> wrote in
messagenews:1177020938.281329.191370@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

|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.
|




.

Relevant Pages

  • Re: Generating Functions with "Concatenate"
    ... using cells to hold the individual components: ... Concatenate to be recognized as commands. ... recognized as a command. ... the same as the concatenated text string. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Memo Update
    ... characters with a LENfunction in Excel so that I know how manu characters ... the string literal contains.' ... directly in the command window. ... succeeds (I get no error message, and upon a subsequent select statement ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Macro for creating a directory file list in a worksheet
    ... I was able to dope out enough of info on the DIR command to come up ... Public Sub LoopThroughXLS() ... Dim sFName As String ... open range of cells until it reaches the last file name. ...
    (microsoft.public.mac.office.excel)
  • Re: Perl Syntax
    ... >>to check for value passed from command line. ... >>exit with an error message. ... Use of uninitialized value in string eq at ./test.pl line 16. ...
    (freebsd-questions)
  • Re: error with string (beginner)
    ... hence your error message. ... Also note that everything input on the command line is a string, ... Check out the Python Cookbook for lots of good examples: ...
    (comp.lang.python)