Skip to main content

Posts

Showing posts from August, 2013

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'…

Facebook - The Social Cigarette!

Facebook - The most popular site of the world with more than 1 billion users. If Facebook were a country it could be in the third place- Just next to the China and India! And within next few years hopefully Facebook will exceed the population of China. Currently Facebook is the strongest online media. 

Why people use Facebook? Why they waste or pass their idle time or even working time on it? Why they can't go a single day without it? 
The answer is Addiction
As the chain smoker smokes cigarettes one by one just for bad habits, many Facebookers waste their time on Facebook without any break. You may browse Facebook at most 2/3 hours a day. But spending more than 6 hours on Facebook is not a good sign at all. 

I'm not a serious critic of Facebook or Facebookers. I'm just anxious about the future of the earth. Few factors are responsible to create imbalance. And Facebook is one of them. By the name of social networking site, Facebook is leading to social imbalance! Should I ex…

AdSense Tips: Best Performing Ad Types & Sizes

I'm currently working with AdSense and learning different tips. And you know, when I learn something I share my knowledge with you. I am willing to share AdSense tips with you. Today I will share the best performing Ad Types and Sizes for AdSense publishers. 

You may also like:  Guidelines before and after getting AdSenseAd Placement Guidelines 10 Years of AdSense

Those who are currently working with AdSense should know, it has different types of Ad Types and Sizes available for the publishers. 
The available sizes are:  Large, Medium and Small RectangleBanner and Half BannerLeaderboardWide and Large SkyscraperSquare, Small SquareHorizontal RowDifferent Types of Buttons

AdSense allows you publish three types of Ads:  Text & Image AdsOnly Text AdsRich Media Ads (ie. Flash) 

Depending on users' demands AdSense provides these ad types and sizes. But all of them are not effective for always. 

The sizes that AdSense found most effective are as follows: 
Large Rectangle: The size of a lar…

How to Type More than 15 Digits in MS Excel?

If you are a regular user of Microsoft Excel then you might be in danger while typing more than 15 digits in a cell. If you type 1111222233334444 then it will be 1111222233334440. Or if you type 25127680876675435 then it will be 25127680876675400. Simply the digits after 15th place will be changed to zeros! Doesn't it seem peculiar? 

Today I will explain when & why this problem occurs and how you can solve it easily. 

When the Problem Occurs?
The problem occurs when you try to type more than 15 digits in a cell like below: 
####-####-####-#### 1234324545679876
But when you press Enter, the output will be 1234324545679870. Excel changes the last digit to a 0. And why someone needs to type more than 15 digits in a cell? It can't be a currency figure. 
Usually when you type a Credit Card/ Debit Card/ BO Account Number you have to type 16 digits. And the calculation of excel doesn't allow you to type more than 15 digits. That's why it converts the last digits (after 15th plac…

Playing with Filename Extensions!

I tried a lot but couldn't create an attractive image for this post. L But I can assure you this image has meaning. Or I can explain the image properly. J  And I'm little bit confused about how to start this post. Because this is somewhat unusual topic. 
Anyway, first I will try to give you a brief idea on filename extensions and then I will try to show you how can you play with these. Let's start . . . 

A filename extension is the identity of the file type. It tells you what the file is, What can you do with it and what you can't. Similarly, your operating system also use the filename extension to execute that file. A wrong filename extension could misdirect your system to treat that file properly. 
If you wanna play with the filename extensions you should have a basic knowledge about the file types. Otherwise you can't understand my point. So if you need more knowledge on file types then read the following post: 

Common File Types with Extensions

And before starting t…