How to create a self signed SSL certificate and how to use it with your web Server.

-
Image
SSL certificate is the foremost important aspect of any website. If your website is running without the SSL, the modern browsers will stop the users from entering the website. Of course, there are ways to bypass that, at your own risk. As long as your website has no commercial data exchange, sensitive user information, etc, you are still good to run a website without a proper SSL certificate. For example, a blog can run without an SSL.  Note that Google AdSense accepts websites without SSL.  But the topic of this post is about Self Signed SSL certificate. How to create one, how to use it, and where to use it.  Let us see where to use it. For any website which is used for internal purposes, it's always a good idea to use Self Signed SSL, instead of paying for a real SSL certificate. Internal I mean, within a company, team, or for personal uses, for testing purposes, etc.  Now, let us see how to create a self-signed SSL certificate.  What you need A Linux machine.  OpenSSL utility  A
Post a Comment

Converting number into text - spellnumber excel function

-
It is often useful to have a function to convert numbers into words in Excel. It will be very handy in accounts. I have written an Excel macro to convert numbers into text. I have already created a macro which will convert a number in Indian system - that is ##,##,### format, to words. You can find it here 

Now I have come up with a macro which does the same thing with the western numbering system, that is 3 digits separation like ###,###,###. The dollar is used as currency, but it can be changed to any currency just by changing the text "Dollar". You can do that by finding replacing.

How to use it:
1. Download the Excel VBA macro module from here 

2. Open Excel 

3. Press Alt + F11 
    A window will open, it is called Visual Basic Editor aka VBA editor. 

4. In the VBA editor select Insert, Module. 
    A new module will be created at the left side pane, on the right side you can see a blank pane. Paste your code here 
    
    Or, alternatively, you can import the module directly
    
5. Save and go back to Excel by pressing Alt + F11

6. In the Excel worksheet, select Formula and them Insert. You will see a dialog with available functions.
    You have to browse to User Defined Functions to your macro by     name ConvertCurrencyToEnglish_spellnumber
    select and provide proper input 

Here is a video showing steps clearly 

Another version of macro for Indian number system


Comments

  1. UnknownNovember 26, 2014 at 11:11 AM

    jese ki 1000 ko convert kiya to one thausand hota h but esme only thapna milta he kinai.. jese ki one thausand only ... karana milta h kinai.. plz help ........

    ReplyDelete
    Replies
    1. Krishna SJanuary 4, 2015 at 4:49 PM

      Please see my latest post.. It will solve your issue

      Delete
  2. ramizJuly 13, 2016 at 6:22 PM

    I just want to let you know that I just check out your site and I find it very interesting and informative..
    excel vba courses

    ReplyDelete

Post a Comment

Popular posts from this blog

Connecting Bluetooth headset with laptop - Bluetooth A2DP

-
A normal phone Bluetooth headset can be easily connected to a laptop and it can be used as earphones or headphones while using skype, gtalk, WhatsApp, or any other voice chat services or of course to listen to your favorite music. All you need to do is a Bluetooth device and the Bluetooth driver with the A2DP(Advanced Audio Distribution Profile) profile. Here is the detailed procedure the setup Bluetooth device with your laptop. Download the A2DP Bluetooth driver from the link provided below. Extract the zip file 'Bluetooth A2DP Driver For Windows.zip'. Go inside the folder 'Bluetooth A2DP Driver For Windows', double-click on the installer file 'anyone-Bluetooth-usb2x0-WindowsXP-v2-1-0-4.exe'. Follow the onscreen instruction to complete the installation.  Once the A2DP driver is installed successfully, Switch on the Bluetooth in the Laptop and Headset. Look for the Bluetooth device the list of available Bluetooth devices. If it is not visible yet, select Add
Read more

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 ) ---------------------------------------------------------------------- ' ****  Author                 : Kr
Read more

[SOLVED] MacBook Pro keyboard backlight not working? Check this post

-
Image
Keyboard backlight not working on your MacBook Pro? And your Mac has a touch bar?  Continue reading... MacBook Pro 2020 which comes with a touch bar has moved its Keyboard backlight controls to the touch bar. You will not see any control on the screen under the Keyboard settings. But the setting in the touch bar is also not easy to see and it bit tricky. You most probably, think that there is some issue with Keyboard. Even the support people suggest resetting some of the settings. That is what happened with my case. Luckily I found a way to change the settings.  By default, the Keyboard backlight settings are not visible on the touch bar. You have to expand the tra-like stuff on the touch bar and then you will find icons, which look similar to screen brightness control icons.  On the right side of your touch bar, you will these 4 controls 1. Screen Brightness control  2. Volume control  3. Mute control  4. Siri button.  Left these controls there is an arrow button which looks like '
Read more