Thursday, April 26, 2012

Excel Formula Field Only Shows Last Two Characters

Okay, this is a dumb one. When highlighting any cell it only shows the last two characters in the formula field.

Can't seem to find a permanent fix yet, but it seems to happen only when using two monitors. The workaround is to view Excel in the primary monitor and the formula field then shows all the cell's contents.

And from my searches, this seems to have been happening since Excel 97...good stuff.

Thursday, April 12, 2012

Removing the U3 Partition from a Flash Drive

I find most extra software bundled with hardware unnecessary and usually annoying; U3 luckily is both.

After attempts to format, fdisk /mbr, diskpart clean, etc. all failed. I did some poking around and found the uninstaller is bundled with the startup app, clever...

  1. Insert your U3 flash drive  and Launch the U3 application.

  2. Click on the U3 Launchpad Settings

  3. Click the Uninstall tab on the Settings menu (all windows and files accessed from the flash drive must be closed).

  4. Finally, click Uninstall U3 Launchpad


That's it, no more pop-ups and annoying software.

Monday, April 2, 2012

Resetting a Verizon MiFi 2200

A recently returned Verizon MiFi 2200 was found to have been reset by the user, with now-forgotten settings. Luckily the reset is easy...

  1. Power on the MiFi (if it isn't already).

  2. Take off the back cover and depress the reset button with a paperclip or similar (look for a hole labelled RESET in one of the corners).

  3. Hold the button in until the status LED turns green, then blinks once (this can take up to ten seconds).

  4. Let it go and then you'll find the SSID listed on the back in your available wireless networks (typically Verizon MIFI4510L XXXX).