ctrl+F command

  • Follow


hi all
 i use the ctrl+F to find a specific number within a column, but sometimes 
excel tells me that the data couldnt be found , knowing that the required 
number is present within the column ..
PS: i use a lot (bold,comma style,font)
any suggestion ??

thanks.......
0
Reply Utf 5/11/2010 7:53:01 PM

Have another think about how the number is stored.

For example, if you look for 123.0, you probably won't find it because it 
will be stored as 123.
Similarly, if you are looking for 123.5 and you think that you can see it 
there, you'll need to check whether you've really got 123.5 or whether 
you've got 123.4999999 displayed as 123.5
--
David Biddulph


"pierre" <pierre@discussions.microsoft.com> wrote in message 
news:72BE3A7E-5B55-46C9-82F1-2E9B64D7BF42@microsoft.com...
> hi all
> i use the ctrl+F to find a specific number within a column, but sometimes
> excel tells me that the data couldnt be found , knowing that the required
> number is present within the column ..
> PS: i use a lot (bold,comma style,font)
> any suggestion ??
>
> thanks....... 


0
Reply David 5/11/2010 8:14:48 PM


1 Replies
396 Views

(page loaded in 0.029 seconds)

Similiar Articles:
















7/25/2012 3:33:19 PM


Reply: