Skip to main content


Showing posts from July, 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'…

Google Scientific Calculator!

Previously I posted about Google Calculator. In that system you are supposed to type your calculation in the Google search box and press enter. The result shows immediately after pressing enter. 
But now it is much easier to use Google as Scientific Calculator. In fact, it is a new sign of innovation by Google. Now you'll get a whole calculator in the home page of Google. And you can calculate just by mouse click. Keyboard is not necessary! 
To perform your basic or scientific calculation you just need to visit Google. Then type calculator and press enter. You can also visit this page to get the calculator directly. Now you'll see a calculator like below. 

Now give input by mouse click and press the equal button and have fun! 

Stay with Marks PC Solution to get more interesting IT topics!

How to Backup or Restore Blogger Blog?

If you're blogger then you may need to backup your entire blog. If you lose your password or if your account is hacked then you can restore your whole blog in a new account. Or you can export your whole blog if you've a back up copy of your blog. 
To back up your blog, follow the steps below: First, make sure you're using the new interface of blogger.Now go to the Settings option and choose Other.Hit on Export blog from Blog tools.Then click download blog.Now your whole blog will be saved as .xml file.

To restore or import your blog, follow the steps below:  Go to the Settings option from blogger and choose Other.Now hit on Import blog.A window will let you choose the .xml file. Now choose the .xml file that you previously download from your blog. 
Stay with Marks PC Solution to get more interesting IT topics!

Submit Your Website or Blog in Search Engines for Free

Web developer or blogger already know that it is not a very easy task to drive traffic from search engines. It takes huge time to perform SEO activities for a site. Forum posting, article writing, social connection, back linking, keyword selection and so many tasks need to be performed for SEO. 

But the most important task is to submit your site in the search engines. The most popular search engines are Google, Yahoo, Bing etc. Besides there are thousands of small search engines available in the web. 

But the submission is a very time consuming task. Specially when you need to submit your site to the search engines one by one. And this is very critical too. For your convenience there are also some sites that make your task easy. All you need to do is just submit your website or blog to those sites and they will automatically submit your site to the search engines. 

DiggzaFree Web SubmissionAdd URL FreeAdd MeSubmit Express
All of the above sites will submit your web or blog to the search e…

Add a Moving Text Bar on Your Blog

Visit Marks PC Solution to get more interesting Tips n Tricks!

Today I will give you a code that is really useful for bloggers. You have already noticed that this post has been started with a moving text. And from this post you'll learn how to add this on your blog. 
Before starting I wanna say you, this bar can be used as news headline or notice bar. Or you can use this for any purpose. It's simply an html code that can be placed anywhere of your blog. If you place it at the top then it can be used as news bar. You can also put it on the side or bottom of your blog. But make sure you're customizing the size and using the bar properly with the place where you wanna insert it. 
Let's start. (Make sure you're using new interface of blogger) First, go to the design option from your blogger page. Then hit on Layout option from the left panel.Now click on Add a Gadget. I suggest to select gadget somewhere from top.  Now scroll down and choose Html/Java Script then copy and …

Security Master Code for Nokia - Use if you forget Nokia security code!

Any mobile has its default security code. And a person may need to change the default security code to enhance the data security. But if the password is forgotten then what? 
In that time you will not be able to access your phone. In that time you can only take it to the service center and expend some money. But If you use Nokia then I have a solution. And this post is going to teach you how to break a security code of Nokia Phone using Master code. Follow the steps below:  Click on this link. In the landing page you will see a box tell you to enter your IMEI number. To check your IMEI number, you can either type *#06# or look for it on the battery of your phone or find it on the packet of your phone. Now type the IMEI number in the given box and check the box showing I'm legal owner of the phone with that IMEI and hit on the generate button. After clicking the generate button you'll be able to see a code below the IMEI number called security master code. You can use this code w…

Built in PDF Reader in Windows 8 !

PDF or Portable Document Format is a great way to share your documents with your friends or even in online. Earlier I wrote about both PDF Creator and PDF Reader. These third party tools for creating and viewing PDF is also very handy. 
But how do you feel if you don't need to install any PDF Reader/ Viewer on your PC! Windows 8 has built in PDF viewer named Windows Reader. It comes as metro app with Windows 8. And it can also read your XPS documents. 
If you're running Windows 8 and you have no PDF Reader installed on your system then you will see your PDF files look orange color. Actually this is Windows Reader. Just double click to open the file. 
Or press the start button and type reader. Then press enter to open Windows Reader. After opening the reader click on Browse to open your files and folders. And select the PDF file you wanna read. 
When using the reader you may not be able to see any toolbar. Because it is a metro app that runs in full screen. Simply hit the right but…

Secret Codes for Nokia !!

Though losing market share gradually, Nokia is still connecting people. Many of us still like Nokia Cell Phones due to its reliability, durability and reasonable price. This post is for the users as well as for the fans of Nokia. 
In this post you'll find some secret codes for your Nokia mobile phone. All codes may not work with all versions of Nokia. And many of these codes will work with most of the models. 
Precaution: Though very much useful, some of these codes may be harmful too! So use these codes with care. Don't take any unnecessary risk while trying them. I'm trying my best to clarify the functions of these codes for your convenience. So before using read the results carefully. 
Type the following codes on the main Screen:  *#06# to see the IMEI number*#7780# to restore factory settings*#67705646# to clear the LCD display (Operator Logo)*#0000# to view software version and date*#746025625# SIM clock allowed status*#62209526# to display the MAC address of the WLAN ada…

How to Make Windows 7 Genuine - Simple & Easy Way

More than 50% computers are running on Windows 7 OS! This is the market leader now. However the Microsoft is going to launch Windows 8 Final Version at the end of the October, 2012
If you're a victim of software piracy and use illegal version of Windows 7 then you may get continuous error message from desktop. And every time when you open your PC a message will tell you to buy a genuine version of windows. Actually this message is very annoying. 
Sometimes you may need to make your OS genuine to install Microsoft Security Essentials. 
In my previous post I wrote about the easiest way to make Windows XP genuine. And in this post I am showing the way to make Windows 7 Genuine! Let's find out how. Download the Zipped file from here. Now extract the file.Now double click on Windows 7 Loader.Then click on install button and restart your PC when asked.And if you're looking for Advanced Settings then select the Advanced options located at the bottom left corner of the window.
Tips: In…

How to Make Your XP Genuine- Just by Double Click!!

It's 2012! That means 10 years have been passed since Microsoft released Windows XP for the first time. Though this OS is obsolete still nearly 50% users use XP in their Computers. 
Sometimes you may have trouble to make your XP genuine. If your XP detected as invalid once  then you are in a deep trouble. You've to install it again. Besides while installing Microsoft Security Essential your OS must be genuine. In that case your Windows XP will show continuous error message about software piracy. 
So, in this post you'll get the easiest way to make Windows XP genunine. Follow the steps below. Download the 1 KB zipped .reg file from here. Double Click on the zipped file to open it.Now double click again and hit yes > OK.Now restart your PC and enjoy the genuine Windows XP.Note: This tips has been tested on Windows XP SP 2. Other service packs were not tested. To check your service pack version, go to properties of My Computer. 

Make Windows 7 Genuine - Simple and Easy Steps


How to Show Hidden Files & Folders of a Flash Drive Caused by Virus

USB flash drive or Memory Card is a great device for sharing files and folders, audio and video, software etc. But at the same time this type of device is also responsible for spreading virus too! A virus can be easily copied from one PC to another by USB flash drives. 

When a PC has no virus protection or not having enough protection be careful when inserting your flash drive in that PC. Because it can affect the software or program stored on it. And other  files like image, audio or video generally not affected by virus. But they may be hidden permanently. 

So, in this post, I am gonna show how to view the hidden files of a flash drive. Let's find out how. Open My Computer.Now click on Folder Options located under tools menu. Now hit on View Tab.Now select the Show hidden files and folders.Deselect both Hide protected operating files and Hide extensions for known file types.Now click on Apply > OK.
Note: This system works for all versions of windows. But in windows 7 and 8 you ma…

Save your Files as PDF in Office 2010!

PDF is one of the most popular method if you wanna share your files. Specially when sharing any report, form or document, PDF is the most reliable and acceptable file format. 
By the way, most of the people use dopdf or other 3rd party software to convert their files into PDF. A procedure of PDF conversion is also posted in this blog. But if you use Microsoft  Office 2010 probably you don't need any other third party software to convert your files into PDF. 
You can convert your files into PDF from the following programs: 
Access 2010Excel 2010OneNote 2010PowerPoint 2010Project 2010Publisher 2010Visio 2010Word 2010To save your files into PDF do the following:  Open any of the above listed programs (ie. Word, Excel or Access) from Microsoft Office 2010. Then hit on the File tab located at the upper left corner of the screen.Now click on Save as to open Save as box.Enter the file name in the File Name box.Now select PDF (*.pdf) from the Save as Type option.

Note: In some cases this syste…

Manually Remove Programs from the Add/Remove Programs List

As an advanced user you may need to install and uninstall different programs on your PC very often. If you do so then you might experience a common problem that almost all other users face. 
That is, sometimes removed program names still shows on the Add/Remove Programs list. Although it creates no problem but enough to bother you. You may think how funny! I removed the program but it shows in the list! 
The main reason of this problem is to delete the program directly from program file instead of uninstalling it. Even it might be caused by any bug in the software. Don't be afraid. Because in this post I am showing an easy and effective solution to this problem. 
Precaution: To do this task you need to modify the registry. So make sure you're capable enough to follow the all steps accurately. Any mistake while modifying the registry may lead to serious problem.  Press Start + R and type regedit in the Open box and hit Enter Button.Now locate and click the following registry file: