Fixing the double-letterboxing effect in Windows Media Player…

To resolve the double-letterboxing effect when playing a widescreen (16:9) movie encoded as fullscreen (4:3) on a widescreen laptop: use Videolan.

Videolan is a freeware, open-source media-player that can help to resolve this problem by providing zoom and crop features that are easily accessible with a right-click while playing the video. If you have an older version, check out the newly released 0.9.* (Grishenko) release – it’s really cool!

Smallest PC in the world?

  • Microsoft® Windows® XP Home/Professional operating system
  • Dimensions: 5.8" x 4" x 1" (148mm x 101mm x 26mm)
  • Weighs 1lb (450g)
  • 1 GHz processor
  • 256MB system RAM
  • 30GB internal hard drive
  • 3D graphics w/ 8MB video RAM
  • Full-function, QWERTY thumb keyboard w/ hotkeys for commonly used commands
  • 5.6" HDTV-quality display (1024 x 600)
  • Lithium-ion Polymer battery (2-6 hours battery life*)
  • Integrated 802.11b (11 Mbps) /g (54 Mbps) Wi-Fi
  • USB 2.0 port
  • Internal microphone/speaker with headphones and ear bud jacks
  • Integrated 1.3MP digital camera

Optional

  • Low-Power Interactive Display (LID) module
  • Bluetooth®
  • Wide area networking
  • Ethernet (10/100Mbit)
  • Support for external VGA
  • NTSC TV Output
  • Additional USB 2.0 ports
  • DVD-CD/RW drive

DimensionsTrue Palmtop!

Displaying Lakhs and Crores in Excel

Here's a useful Excel tip for users in India and other places that use number formats like 100,00,00,000 instead of 1,000,000,000:

You may have faced the problem of Excel always displaying amounts in millions and not in lakhs e.g. 1,000,000 instead of 10,00,000. Here's a trick to get them to display correctly:

Right-click on the cells which you want to display as lakhs, and click on Format Cells, then go to the Custom category and enter the below formats:
For Lakhs (+ve and -ve):

With 2 decimals:

[>99999]##\,##\,##0.00;[<-99999.99]-##\,##\,##0.00;##,##0.00

Without decimals:

[>99999]##\,##\,##0;[<-99999.99]-##\,##\,##0;##,##0

For Lakhs and crores (+ve)

[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

For Lakhs and crores (-ve)

[<-9999999](##\,##\,##\,##0.00);[<-99999](##\,##\,##0.00);##,##0.00

There is an easier way to change the global settings from Settings > Control Panel > Regional Settings > Numbers, but that will affect all your Excel sheets and the change will be visible only on your system and not on your files which you send to others.
Happy XL-ing 🙂