Skip to main content

Posts

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

Twin Tower Attack Trick by Notepad!

This post heading may surprise you! Is it possible to attack Twin Tower by notepad? Yes you can do this! And not only by notepad, you can do this by MS Word too. Notepad has many funny tricks. And today's trick is nothing but a mechanism of Wingdings font. 


Almost all of you are familiar with the Twin Tower Attack as on September 11, 2001. This attack is widely known as 9/11 attack. You might also know that the flight number of the plane that hit Word Trade Center was Q33N.


Let's find out what Q33N gives us in notepad when we use Wingdings font: 

Open Notepad. (Press Start + R > Type Notepad > Hit Enter)Type Q33N in block/ capital letter.Choose Wingdings font from the Format menu. For better viewing, choose 72 as font size. And see the magic!
You may call this trick a coincidence or something else but whatever it is, it was very shocking. 

Note: After applying this trick, all of your notepad documents will be converted into Wingdings font. And it may cause some problems. So, …

Convert Text into Audio by Notepad!!

In this post I am gonna show another amazing trick of notepad. Here you will learn how to convert text into audio using notepad. But you will just be able to listen the audio not save or keep it in your hard disk. 
To do so, just follow the steps below: 
1. Open notepad. ( Press Win Key  + R > type notepad and hit enter) 2. Type the following message in the notepad:  Dim msg, sapi
 msg=InputBox("Enter your text for conversion–www.munnamark.blogspot.com","Marks PC Solution Text To Audio Converter")
 Set sapi=CreateObject("sapi.spvoice")
 sapi.Speak msg
3. Save the file with .vbs extension. (Example: Text to audio.vbs)
Now you're almost finished! When you open up the file you will see a window like the right one. 
Now type your text in the blank space of the window and hit the ok button. It will speak your text loudly. Make sure your speaker is on. 

NB: By this trick you can also know whether your PC is male or female!

Cheat Codes for GTA Vice City!!

GTA Vice City was released several years ago. This is somewhat old game now. But even it is very popular in the gaming world. Specially this game is suitable for the beginner. 
While playing the game or at the pause menu, enter one of the following codes to activate the corresponding cheat function. If you entered the code correctly, a message "Cheat Activated" will appear.

And never place a space between the cheats which has more than one word. Words are capitalized and separated so that they can be easily viewed and memorized. You should only type the words without any space and capitalization. 
Result
Cheat Code Health [Note 1]AspirineArmorPrecious Protection Weapons (tier 1) Thugs ToolsWeapons (tier 2)Professional ToolsWeapons (tier 3)Nutter ToolsRaise wanted levelYou Wont Take Me AliveLower wanted levelLeave Me AloneView media level when over two starsChase StatBetter driving skillsGrip is EverythingDodo cars (flying) [Note 2]Come Fly With MeRhino tankPanzerFaster game …

Make a Diary Using Notepad!

Most of the people know that notepad is used to create and modify plain text. But very little of them know about its useful applications. It has many tricks. In this post I am gonna show a small trick of notepad.


You can make a diary using notepad. To do so simply follow the steps below:

1. Go to run by press Windows Key + R then type notepad and hit enter.
2. Write .LOG in the notepad.
3. Save it as Diary or any other desired name as your choice. (Make sure that your file format is .txt)

Now when you open up this file, each time it will insert the date and time of opening the file just as below:



NB: If you don't use this trick but wanna insert date and time in the notepad simply hit the F5 button of the keyboard.

Laptop Vs. Desktop: Which one should you buy?

Day by day the use of mobile PC (laptop, notebook, tablet) is increasing rapidly. Most of the computer users are no longer interested in desktop computer. Of course there are some logical reasons behind this trend. Laptop is portable, easy to move, smaller in size and so many. 

But this is a very rare case that a person use laptop but doesn't suffer a lot! Because laptops are not so strong like desktop PCs. They are small in size as well as small in capacity too! Repairing a desktop is relatively easy. But rearing a laptop requires some extra skills.  
Laptop is really a sensitive device. Anytime your keyboard or touch pad can be damaged. And this is not very easy to replace the parts of laptops. Though it might have warranty for around two years but when you give it to the service center they may give it back to you after several weeks. 



Now the question is what should a person buy-Laptop or Desktop?


Well the answer depends on several factors . . . Computer experts suggest to buy desk…

DirectX Diagnostic Tool: dxdiag

Sometimes you may need to analyze your system configuration. If your PC gets damaged and needs to take it to the service center then you should check the system configuration. Unfortunately if the experts of service center are dishonest then they might change your system. For example you have 2 GB RAM. They can replace it with an 1 GB RAM. Your Processor may be Dual Core. They can replace it with a Pentium 4 processor.
With DirectX Diagnostic Tool you can see the detailed information about the hardware and drivers installed on your system. You can view the system manufacturer, system model, processor capacity, RAM, DirectX version, Video Card, Sound Card and so many.
To open DirectX Diagnostic Tool, simply go to the Run by pressing Start + R, then type dxdiag and hit enter. Now a Yes/ No option may appear. Just hit on the yes button. Now you will see a window named DirectX Diagnostic Tool.


Well in this window you can see several options ie. System, Display, Sound etc. 


System: In this t…

Lost your Motherboard CD? Simply go to the Manufacturer's Web Site!

Every motherboard manufacturer and most of the other device manufacturers provide a driver CD for the hardware to make it compatible with Operating Systems. Except some plug and play device such as Monitor, Keyboard, Mouse, Speaker most of the other devices have a driver CD. 
But in case devices like printer, scanner, webcam, sound card, graphics the driver is essential. Even some modems don't work without external driver. 

At least 20 to 30% people lost their driver CD due to their carelessness! And when they re install the OS they lost sound and graphics options! And try to find a CD here and there. And unfortunately driver CD are not same for different models of devices. 
But it is very simple to recover the lost CD! You can find it from the manufacturer's website. For example, if you lost your HP Laptop's Driver CD, just visit www.hp.com. And Search by writing the device name and model in the search box. 
Here are some of the common websites that may be helpful for you: 1.

Goodbye BIOS

Goodbye BIOS, Welcome UEFI

Your computer's basic input/output system (BIOS) is about to become history and be replaced by Unified Extensible Firmware Interface (UEFI). Without compatibility problem, it has no pitfalls. 

When you turn on your system, a primitive system that dates back more than 30 years, the basic input/output system (BIOS), turns your cold hardware into a functioning system that your operating system can then boot from.

Can you imagine?! 30 years in the field of technology! Where things are changed within 30 seconds BIOS are surviving for 30 years! How can it be possible? Due to the compatibility problem this obsolete technology is surviving for a long time. Now it is time to change and upgrade. 
Hardware manufacturers are slowly replacing BIOS with the Unified Extensible Firmware Interface (UEFI). That's all well and good, but one UEFI feature, Secure Boot, could be used to lock PCs into being only able to boot one operating system: Windows 8. 
So, what's r…

Built in Security in Windows 8

If you're using Windows 8 then you don't need to purchase Anti Virus or Security Tool! Windows 8 has a built in antivirus program named Windows Defender. Windows defender was also included with windows vista and 7. But its functions were very limited. In windows 8, defender has been redesigned like Microsoft Security Essentials. The skin and interface of New Windows Defender is just like MSE. But maybe there are significant changes in case of performance. 



Earlier Microsoft released free security software for PC users- Microsoft Security Essentials. But it was not default. To enhance the security of new Windows, defender has been included with it. Certainly you'll enjoy this.  





Features and Facilities: 

100% Free (No Option of Serial Key or Crack!)No installation required- Built inFast, safe and reliable ScanReal Time ProtectionNever Slow Down PCNo Unnecessary MessagesOptions to allow, remove, disinfect or quarantine the infected objectsCapability to Disinfect the infected fi…

Windows 8 System Requirements

Windows 8 is the latest version of windows. Original version of windows 8 is not released it. Hopefully it will be launched within few weeks or months. Hardware manufacturer are also working to make devices that is compatible with this OS.

But what about the current hardware. IT lovers wanna know about the requirements of windows 8. Microsoft says, if your PC supports windows Vista and 7 you will be able to run Windows 8 too. Sometimes windows 8 requires less amount of resources that windows 7!



Windows 8 System Requirements

The Windows 8 Developer Preview works great on the same hardware that powers Windows Vista and Windows 7:
1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
16 GB available hard disk space (32-bit) or 20 GB (64-bit)
DirectX 9 graphics device with WDDM 1.0 or higher driver
Taking advantage of touch input requires a screen that supports multi-touch
To run Metro style Apps, you need a screen resolution o…

Windows 8 Download

By this time, hopefully you all have already heard about Windows 8. Actually it is just a preview of original OS.  Though it is a preview, I was very curious about it. 
In order to test it I requested one of my friends to download it for me. After getting it, I installed Windows 8 on my system and found a new world of computing! 
There is a revolutionary change in Windows 8. At first glance you may be lost your path in the wonderful options of windows 8. But keep using it for some days. You will just love it.
You can find something more about windows 8 here


For 64-bit version, go here
For 32-bit version, go here


You might have a question. Will I be able to run windows 8 on my system? 
The answer is very simple. If your PC supports windows 7, then windows 8 will also run on it. 


Click here if you want Windows 8 Release Preview.