Make search companion as default windows default search engine with windows desktop search intalled

Make search companion as default windows default search engine with windows desktop search intalled


(hit Start > Run then type 'regedit'). Go to the following node:

HKEY_CURRENT_USER\Software\Microsoft\Windows Desktop Search\DS

Then double-click on 'ShowStartSearchBand' and set the value to '0'.



Full explanation:

Much though I love the newly released Microsoft Office 2007, one thing bugged the hell out of me. To get search to work in Outlook (and search is handy if you want to find specific emails from 6 months ago with work you were supposed to have done by now) you need to install Windows Desktop Search 3. This is all well and good until you decide you want to search for files on your hard drive.


Yep, it's replaced the standard Windows search companion (and the friendly dog). That's all well and good, except it's an indexed search so doesn't necessarily reflect what's really on disk. And since by default my program files folder isn't indexed, it never shows any results no matter what I search for – until I go in and change the settings then wait for it to get around to indexing the folders.

There's a link at the bottom of the tab to use the trusty old search companion, but it means clicking it every time. Oh, and before you ask, no, there isn't an option to disable this irritating integration in WDS! I hate it when software comes along and arrogantly replaces existing functionality with itself and gives no way to remove it. I only put the thing on so Outlook would be able to search emails, not to make me click more buttons to search for files!

Of course, you can in fact turn it off, as a little digging has turned up. Simply open RegEdit (hit Start > Run then type 'regedit'). Go to the following node:

HKEY_CURRENT_USER\Software\Microsoft\Windows Desktop Search\DS

Then double-click on 'ShowStartSearchBand' and set the value to '0'. Close that and you're done, the next time you click 'Search' in explorer, the old, reliable search companion will appear. This applies to operating systems before Windows Vista, since Vista has far better search that actually works! (Okay, now someone will say it just uses WDS and I'm an idiot – wouldn't be the first time).

Excel: convert seconds to minutes

An alternative to maintain your time data integrity ie. if you change the format
would be to use the following formula

=YourCell/(60*60*24)

The division by 60 * 60 * 24 is neccessary
because Excel stores all dates as integers and all times as decimal fractions. Excel takes your value as been a single day or 24 Hour
period eg enter 2 = 2days = 2 24hr periods =2*60*60*24 secs
Times are stored as decimal numbers between .0 and .99999,
where .0 is 00:00:00 and .99999 is 23:59:59

and then format your cells like this;

In the "Format cells" Dialog
Select Custom
In the "Type:" box
Type in "mm:ss"

This should give you the results as Minutes Seconds
Use the format painter to copy the custom formats to
your data range.