Featured post

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding ...

Converting Numbers into Words in Excel



Convert Numeric Value to English Words by Excel


Well, actually MS Excel doesn't include any direct function to convert your numeric values into words. But with the help of Microsoft Visual Basic, you can input a module in your worksheet and convert numbers into English words. Let's do this - 



Applies to
  • Excel 2003
  • Excel 2007
  • Excel 2010
  • Excel 2013
  • Excel 2016


Prepare Workbook for Conversion
  1. Run MS Excel (I'm using Excel 2016).
  2. Open a new/ blank workbook.
  3. Press Alt+F11 to open Microsoft Visual Basic.
  4. Go to the Insert Menu > Module > Copy and paste the following code in the blank box.
  5. Press Alt+Q to close and return to Microsoft Excel.
  6. Go to the file menu and save this workbook as Excel Macro-Enabled Workbook (*.xlsm). I.e. Word Converter.xlsm. That's it!


Function words(fig, Optional point = "Point") As String    
Dim digit(14) As Integer    alpha = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")    figi = Trim(StrReverse(Str(Int(Abs(fig)))))    For i = 1 To Len(figi)    digit(i) = Mid(figi, i, 1)    Next    For i = 2 To Len(figi) Step 3    If digit(i) = 1 Then    digit(i) = digit(i - 1) + 10: digit(i - 1) = 0    Else: If digit(i) > 1 Then digit(i) = digit(i) + 18    End If    Next    For i = 1 To Len(figi)    If (i Mod 3) = 0 And digit(i) > 0 Then words = "hundred " & words    If (i Mod 3) = 1 And digit(i) + digit(i + 1) + digit(i + 2) > 0 Then _    words = Choose(i / 3, "thousand ", "million ", "billion ") & words    words = Trim(alpha(digit(i)) & " " & words)    Next    If fig <> Int(fig) Then    figc = StrReverse(figi)    If figc = 0 Then figc = ""    figd = Trim(WorksheetFunction.Substitute(Str(Abs(fig)), figc & ".", ""))    words = Trim(words & " " & point)    For i = 1 To Len(figd)    If Val(Mid(figd, i, 1)) > 0 Then    words = words & " " & alpha(Mid(figd, i, 1))    Else: words = words & " Zero"    End If    Next    End If    If fig < 0 Then words = "Negative " & words    End Function



Run the Function

After going through the above options, your Word Converter.xlsm document is ready to convert numeric values into English words. Now follow the steps below:
  1. Open your Word Converter workbook.
  2. Type a digit in a cell. i.e. type 2124 in cell C6. 
  3. Put your cursor in a different cell i.e. C7.
  4. Type =words(C6) in cell C7. And you will get Two thousand one hundred twenty four.


Convert Number into Words in Excel


Look at the formula bar: =words(A2)


Or you can also use this method - 
  1. Type your digit and put your cursor in a different cell.
  2. Go to the Formula > Insert Function > Select a Category > User Defined.
  3. Now choose Words from Select a function.
  4. Choose your desired cell and hit OK.

Insert Function Dialogue Box



Warning Message!

When you close this document and reopen for the first time, Excel may warn you like - This document contains macro. And you should hit on the Enable Content button. If you don't hit the enable button, then word converter function may not work.



Lots of works to do ha? Seems complicated? No problem. I'm sharing a sample workbook for you. Just download and do your work. :) 






Thanks for visiting us - enjoy your day! 




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



Use Hue/ Saturation to Modify Color in Photoshop



Modify Images by Hue/Saturation



Adobe Photoshop offers some extraordinary photo editing tools that make it a great program to the users. Hue/ Saturation is one of them. With this tool you can modify the color of your photos and images. Let's explore this tool . . .



Necessary Tools
  • Adobe Photoshop (I prefer CS5 or 6)
  • Some photos or images (I prefer flowers)


Adobe Photoshop Hue/Saturation Option



Using Hue/ Saturation
  1. Open Photoshop.
  2. Go to the File Menu > Open an image you need to modify.
  3. Now go to the Image Menu > Adjustment > Hue/ Saturation (Keyboard Shortcut: Ctrl+U)
  4. You will get three options: Hue to modify the color, Saturation to adjust the amount of color > Lightness to adjust the lighting.
  5. Move the slider of Hue (left to right or right to left) and observe the changes.
  6. You can also try other options here (at your own responsibility).
  7. Finally, press OK and Save your image. That's it!


Showing you some Illustrations:

Example 1


Flowers & Fruits


Open it using photoshop > Image > Adjustment > Hue/ Saturation > Change the value of Hue from 0 to -55. And you will get the following view:


Amazing Flowers and Fruits


Example 2


Flowers and Leaves


Here I've used -75 in Hue and got the following image - 

Modified Flower



Modify the Color of a Part . . .

If you don't need to modify the color of whole picture then you can select the part you wanna modify. Simply use the Marquee tool by press M.


Modified Tulip Flowers in Vase


Lots of flowers ha? You can download them all!! 



Keyboard Shortcuts used in this tutorial - 
  • Hue/Saturation: Ctrl + U
  • Open: Ctrl + O
  • Marquee Tool: Ctrl + M
  • Crop: C
  • Polygonal Lasso Tool: L
  • Move Tool: V


Glad to get you here. Keep reading . . . 



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





Claim your Business on Google Maps . . .



Verify your Business on Maps



In my previous post I discussed about adding your business to Google Maps. And in this post I would like to talk about claiming a business on Maps. If your business is not already listed on Google then you can read my previous post. But if your organization is already listed then you're good to go . . .



Prerequisites for Claiming your Business
  • Your business should be listed on Google Maps


Necessary Tools
  • Android Phone with GPS & Data Connection
  • Google Maps Application
  • Browser (I prefer Google Chrome)
  • My Business App (Optional)


Steps to claim your business on Maps




Steps in Claiming the Business
  1. Open Google Maps on your Android Device.
  2. Search and locate your business on Maps.
  3. Tap on your business and it will prompt you to a new window.
  4. Choose the option - Claim this business.
  5. Now you will be redirected (maybe by your web browser) to this address - business.google.com.
  6. Here you need to confirm your business. Tick the option - I'm authorized to manage this business . . .  > Continue.
  7. Tap on the Mail button > Google will show you postcard sample > Type a contact name if necessary > Hit on the Send Postcard button.
  8. Within few weeks (less than 30 days) this postcard should reach the destination. 
  9. After you get the postcard, get the PIN from there, and follow the steps again. Finally verify your business location by entering the PIN. That's it!


Claim your business postcard


Verifying your business address on Google will provide you several advantages. When people search for your organization using Google search, Google will show your business location on Google Map, including your phone number and web address.

And from that search result, your prospective clients can make direct phone call to you. It will also include photos and images you provided.


Hopefully this post will help you. Continue with Marks PC to get more useful contents in the future . . .





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