Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 42
Default Why does the Edit Find feature in Excel not work?

Whe I go to Edit Find to locate a specific number in my Excel spreadsheet
it says that it did not find it, yet the number is there. What might be
wrong? Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default Why does the Edit Find feature in Excel not work?

It may be a formatting issue. For example, if you have 15 in a cell, but the
cell is formatted as Currency, you might see $ 15.00 displayed. A search for
15.00 would not result in anything being found since only 15 is actually
stored in the cell not 15.00.

If you still need help, perhaps post back with an example of the data you're
trying to find.

HTH
Elkar




"trainer07" wrote:

Whe I go to Edit Find to locate a specific number in my Excel spreadsheet
it says that it did not find it, yet the number is there. What might be
wrong? Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2003 excel had an edit fill justify feature. Does 2007? welk Excel Discussion (Misc queries) 1 November 6th 08 01:56 AM
Edit/Find feature in Access 2003 Creating Outlook appointment Excel Discussion (Misc queries) 1 March 9th 07 03:09 PM
Why doesn't the automatic fill feature work in excel? JenniferO Excel Discussion (Misc queries) 4 May 10th 06 08:15 PM
Edit-Find doesn' work, don't know the problem. Gary''s Student New Users to Excel 0 September 17th 05 12:27 AM
Edit-Find doesn' work, don't know the problem. micasidulce New Users to Excel 0 September 17th 05 12:27 AM


All times are GMT +1. The time now is 05:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"