Skip to main content

Posts

Showing posts from April, 2012

Featured Post

Changing Digit Grouping (Comma Style) in MS Excel - Million to Lakh

Well this is a very common problem for our sub-continent i.e. Bangladesh, India, Pakistan, Nepal, Maldives, Sri Lanka. Cause our digit grouping system doesn't match with the international system. To be more specific - they use million, billion etc. But we use - lakh (also lac), crore etc. 
Users of the mentioned regions often face problem with the comma separator position in MS Excel. Cause the default system is international. It doesn't suit our digit grouping system. 
International System - Separates every three digits 1,000.0010,000.00100,000.001,000,000.001,000,000,000.00
Subcontinental System - Separates every two digits after the 1st three digits
1,000.0010,000.00 1,00,000.001,00,00,000.001,00,00,00,000.00 
If you're familiar with the Indian Subcontinent system and if you're bound to use this system then it will be a big trouble if you don't know the solution. Well nothing to worry about as you are going through this article. Cause from the very next moment you'…

15 GB Storage for Gmail Users!

Recently Google increased the storage limit of Gmail. Few days ago the storage limit was 7.5 GB. But from now the storage limit is 10 GB! Can you imagine?! 
The storage limit is based on the size of all the messages and attachments in your mail, including those in Spam and Trash. To introduce the Google Drive as Cloud Service Google offered this increased storage. 
Mentioned that, Gmail was launched by Google on 1st April in 2004. At first, the storage limit was only 1 GB. And it has been increased upto 7.5 GB within 8 years. And now it is 10 GB. An user can check this at the bottom of his Gmail Page as the picture shows. 


Update

Google got a number of competitors in mailing service - specially Microsoft and Yahoo too. Recently Microsoft redesigned their hotmail service. They also changed the name to Outlook.  And yahoo has also redesigned their mailing service. Now it looks much better than earlier. 
Google has also changed the Gmail interface for a number of times. But still it looks som…

How to Check Cell Phones Quality Using IMEI - *#06#

Most probably, mobile phone is the most used device by the people throughout the whole world. Couple of years ago the use of mobile phone was very limited. But today many users have more than one or two mobile phones.
And to meet the demand, manufacturers are producing their products in different places to reduce the cost. Sometimes mobile phones are produced in China, India or any other country where production cost is relatively low. And quality is also hampered for this reason.
So, in this post I am gonna show you, how do you check your mobile phone's quality using the IMEI number
IMEI stands for International Mobile Equipment Identity. It is a 15-digit number and may be found in the packet of the mobile phone. It may also be found by removing the back cover and it may be placed on the battery sticker. 
If you lose your IME number then you can find it by typing *#06# on your mobile screen. After pressing this code, you will see a 15-digit number immediately on the screen which is…

What is the Difference between LCD & LED Monitor?

Couple of years ago, giant monitor manufacturers declared that CRT (Cathode Ray Tube) monitors will no longer be available in the market as it consumes heavy power produces low quality output and most importantly better technology is available I mean LCD Display.  
CRT Monitor was the only one choice of customer for a long time. Then LCD overthrows it from the market. But LCD's time was too little. Within a very short time another technology that is LED has arrived and the time of LCD is almost finished now. 
Many people are often confused with the two terms - LCD and LED. As they look same, both are thin and smart so many people can't make a difference between the two. In this post I wanna clarity the difference between the two. 


LCD Vs. LED Monitor: Basic Difference
LCD (Liquid Crystal Display) LED (Light Emitting Diode) 
LCD and LED monitors are based on the same basic technology for image display, but differ in case of back-lighting technology used. While LCD monitors use …

Sleep & Hibernate Option in Windows 7

In windows 7 there are sleep and hibernate options. Many users are often confused with the two options. Some of them can't make difference between the two. So, in this post I'm gonna clarify the difference between sleep, hibernate, and hybrid sleep?
Before finding out the differences lets start from the very beginning. I mean I wanna start from the Shut Down Option. When your all tasks are over you can shut down your PC. Shut down puts down your computer in a state from where you will not be able to get your previous session. Everything will go to its initial stage. Any program or windows that were running will not be running  next time when you turn on the PC. Every user I think knows about shut down. 
Sleep: It isa low power-saving state that allows a computer to quickly start full-power operation (typically within several seconds) when you wanna start working again. Putting your computer into the sleep state is like pausing a DVD player-- the computer immediately stops what…

Use of Ctrl+A to Ctrl+Z for MS Word!!

While working with MS Word we often use Ctrl+A, Ctrl+C, Ctrl+D etc. But do you know that MS Word has shortcuts keys available from Ctrl+A to Ctrl+Z? 
In this post I am gonna show you the shortcuts from A to Z with Ctrl Key. 
Ctrl+A: Select All Ctrl+B: Bold Ctrl+C: Copy Ctrl+D: Font Ctrl+E: Center Alignment Ctrl+F: Find Ctrl+G: Go to Ctrl+H: Replace Ctrl+I: Italic Ctrl+J: Justify  Ctrl+K: Hyperlink Ctrl+L: Left Alignment Ctrl+M: Intend Increase (Works same when Tab is pressed before a line) Ctrl+N: New Document Ctrl+O: Open Document Ctrl+P: Print Document Ctrl+Q: Remove Paragraph Format Ctrl+R: Right Alignment Ctrl+S: Save (Use F12 for Save As) Ctrl+T: Hanging Indent Increase Ctrl+U: Underline Ctrl+V: Paste Ctrl+W: Close (or use Ctrl+F4/ Alt+F4) Ctrl+X: Cut Ctrl+Y: Repeat/ Redo Ctrl+Z: Undo
Note: Many of the above shortcuts also work fine with many other programs.

How to shorten a long url?

Sometimes you may need to provide a web address (or url) to your friend or someone else. If you give it using email then it is easy. Just copy and paste the whole url.
But if you need to send it by Mobile SMS or if you need to write in on a paper then you may need to type it manually or write on a paper. In case of small url it is not very difficult job.
But if the url is too long then it will really a tough job for you. And most importantly there is a chance of mistake. Because often a web address consists of many meaningless letter or symbol. And if you miss a single letter your link will be unusable!
But there is a system to make your long url short. Tiny URL will let you shorten a long url.
For example, type http://munnamark.blogspot.com in the box and click on tiny. Then the short link will be like that http://tiny.cc/7n96bw. And this small link will work perfectly like the original url.
You can also make a custom url. First copy and paste your url in the url box. Then type a custom n…