Hamideh sends in an interesting question. He set up a really cool custom number format to prevent people from having to enter 4 dashes in a part number. However… now Find appears not to work. In Episode 673, I will show you the hidden setting to assist with the Find.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!