Posts

Convert currency to word in excel

There are plenty of online resources to convert Numeric currencies to Text- from $200 to Dollar Two Hundred. But this is applicable only ###,###,### (comma at every third number)format.  This is not suitable for India numbering system, because we follow ##,##,###(....22,22,222) format. So I have create a excel function to over come this. You can use this function to to convert number up to 10,00,00,000(ten crores). How to do it Open Excel Press Alt + F11 From Menu Bar  Insert Module Copy paste the This Module there. Exit from VBA window by pressing Alt + F11 again In excel sheet, Insert Function, Under user defined find   ConvertCurrencyToEnglish  select it and provide the number as a parameter thats all you are done ---------------------------------------------------------------------- Code (alternatively you can download the module from here ) ---------------------------------------------------------------------- ' ...

Enable or Disable GPRS/EDGE in iPhone - The Simple way

Image
I use the iPhone 2g with Bharthi Airtel in  India. It Unlocked and jailbroken. I had a problem with editing APN settings (GPRS/EDGE settings), in fact, it's intentionally done b y Carrier. They are hidden; you will not be able to see Cellular Data Network option under Settings-> General->Network-> Cellular Data Network To enable or disable GPRS the only option, I think, is to change the settings here. To do this all you need is 1.        Jailbroken iPhone with USB Cable 2.        A PC You don't have to worry about Wi-Fi or SSH or WinSCP or even Cydia Download. The procedure –ITS VERY SIMPLE J 1.        Download install iPhone explorer and plist editor for windows they are free and simple use 2.        Connect you iPhone via USB cable (make sure your iTunes recognizes it) 3.        Run iPhone explorer Click on ...

How to change the font size of Browser in iPhone

If you find it difficult to read the text in iPhone browser here is the solution Just follow these steps 1.       Go to any web site you want. 2.       After loading click on the address bar of the browser 3.       Delete whatever you have in the address bar. 4.       Paste the below code in the address bar  javascript:for(i=0;i<document.getElementsByTagName ('*').length;i++)void(document.getElementsByTagName('*' )[i].style.fontSize='18pt'); 5.       Tap on Go button at the bottom Notes: you can change the value 18 to whatever font you want. Make sure that you do not have any New Line character int code.