Of Halves And Sixteenths

There are many options in the “Fraction” category of Excel’s number formatting. It seems to us that you’ve chosen the “As sixteenths” option. This, taken literally, means every fraction is rounded to the nearest sixteenth, and is then displayed in sixteenths-as in 8/16 instead of ½.

One option is to choose “Up to two digits,” in which case you would see 1/2 rather than 8/16. The drawback is that you would also see fractions such as 51/82! You may therefore need to create a new column to display your values in sixteenths. If the base value is in cell A1, the function “=MROUND(A1/2.54,0.0625)” would give the value rounded to a sixteenth. After applying the formula, format the cell with “Up to two digits.”

Shoo, Doggie!
Q. I use Windows XP Professional. Whenever I double-click on any folder in Windows Explorer, the Search Companion pops up. How do I get rid of it?
Prathamesh Mahindre
 
You will need to edit the Registry to get rid of the Search Companion. But we’d like to warn you that you should proceed only if you’re familiar with editing the Registry: one wrong step could render Windows unbootable.

Modify Registry key to open folder on double-click

In the Registry Editor, navigate to “HKEY_CLASSES_ROOTDirectoryshell”, and locate the “Default” entry in the right pane. Click “Modify” to change the value, and enter “none” in the “File” data box. Click OK and exit the Registry Editor. That should make the little dog go away!

Squish!
Q. I have Windows XP installed on my computer-a Pentium 4 2.4 GHz with 512 MB of RAM and an 80 GB hard drive. I have a broadband connection. I suspect that a virus has infected my computer. I find small executable files in each folder with their names as that of the root folder. What can I do?
Kalyani Guhathakur

Your computer has been infected by W32.Traxg@mm, which is a mass-mailing worm that sends itself to all addresses in the Microsoft Outlook address book. This is not a high-risk worm-all it does is send copies of itself to various e-mail recipients. Removal of the worm is very easy-just follow these steps.

1. Install an anti-virus and update the virus definitions from the vendor’s Web site.
2. Disable System Restore. To do this, go to Control Panel > System > System Restore, and tick the box next to “Turn off System Restore on all drives”. Click OK.
3. Restart the computer in Safe Mode.
4. Run a full system scan and delete all the infected files detected during the scan.
5. Open the Registry Editor. Navigate to “HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionRun”. In the right pane, delete “TempCom” = “%WinDir% Fonts<randomname>.com”, where “randomname” can be any random file name. Exit the Registry Editor and restart the computer in normal mode.
6. You may also want to restore the default settings of Windows Explorer that were changed by the worm. To do this, start Windows Explorer, go to Tools > Folder Options > View, and click the Restore Defaults button. Click OK and close Windows Explorer.

Seeing Double
Q. I use Windows XP Home SP1. Add or Remove Programs displays two entries for some programs I’ve installed. How do I correct this?
Anil Kumar Sahoo

Sometimes, when you uninstall a program and install a higher version, or when you install a newer version of a program over an older version, the entries of the old program are left in the Add or Remove Programs applet. This happens because some programs do not correctly remove the Registry entries of the uninstall string for the program while being uninstalled or upgraded.

Use XQDC X-Setup Pro to remove the duplicate entries in Add or Remove Programs

To correct this problem, download and install X-Setup Pro from www.x-setup.net. This is a system configuration and tweaking utility. Launch the program and navigate to System > Software Installation > Add or Remove Programs, and click on Add or Remove Programs List Editor. In the right-hand side, you can view the entries that appear in the Add or Remove Programs applet. Click on an entry and click Delete to delete it. You can also click on Edit Name or Edit CMD to edit the name of an entry, or to view the uninstall command associated with that entry. Close X-Setup and your problem should go away-no reboot is necessary.

In IE, go to Tools > Internet Options. In the General tab, you should find a panel in the centre called “Temporary Internet Files.” Click Settings in this panel, and a dialog box will appear. Here, click View Files. You’ll now be able to see all your cached temporary Internet files. That’s precisely what you want-delete whatever you need to.

To Boot Or Not To Boot, …
Q. When I boot up my PC, I get this message: “Primary Hard Disk 1 not found. Push F1 to continue, F2 for setup utility.” But when I press [F1], the system boots normally and runs fine. What could be the problem?
Navneet Joshi

There is more than one reason for this to be happening. Your BIOS is set to boot from the non-primary hard disk first. Most BIOSes have settings to re-order device booting, and some of these settings are buggy. The BIOS might not automatically look for the next available bootable device, and that’s why the error message pops up. You will have to enter the CMOS setup and set your detected hard drive as the first boot device. Your problem should go away.

Another cause could be that your hard disk is taking some extra time to spin up. If this is happening, the system-which could be trying to boot fast-might not see the disk. You can fix this in the BIOS: usually, there’s a setting called “Hard Drive Pre Delay” or “Hard Drive Pre-Boot Delay.” Set this for a reasonable time such as 10 seconds to allow the disk to spin up.

All Spaced Out
Q. Double-spacing is required for my essays in MS Word. I’m using Word 2003. How do I configure it to automatically double-space?
Prakash Pundit

This is quite simple. Open a new document, and go to Format > Styles and Formatting. Look for “Normal” at the right of the Styles and Formatting panel, and select it. Click the arrow next to Normal and select Modify. Click Format at the bottom left of the Modify Style dialog box, and choose Paragraph. Now look for the Line Spacing setting and make your changes-from Single to Double. Now in the Modify Style dialog, select the Add to Template checkbox, and click OK.

A Question Of Credentials
Q. When I try to schedule a new task in the Task Manager, I get an error saying that the new task has been created but that it might not run because the account information could not be set. Task Manager reports error 0x80070005: “Access is denied.” It says to use the Browse button to locate the application. What do I do?
Mahesh Verekar

When you schedule a new task, you need to give it the account name and password under which it will run. This ensures that the task can run even when a different user-or no user-is logged on. Remember that for scheduling a new task, you need to use an account for which a password has been defined: it’s when you try to use an account that has no password, or if you omit the password, that you’ll get the error you described.

If the account and password are fine, the problem could be with Windows. Microsoft has acknowledged a problem in XP SP2 that can result in this problem. They will release a hotfix for this. In the meantime, you can obtain a patch from Microsoft by linking from the KB article at http://support.microsoft.com/ kb/884573.

XP Home users will have to wait for the hotfix. If you’re running XP Pro, you can rectify the problem using the Group Policy Editor. Navigate to Local Computer Policy > Computer Confi guration > Windows Settings > Security Settings > Local Policies > User Rights Assignment. In the right-hand pane, double-click Access this computer from the network. Click Add User or Group, enter the account name you’re using for the scheduled task, and click Check Names. Click OK twice and close the Group Policy Editor.