Saturday, May 28, 2016

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!



Saturday, May 21, 2016

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!



Saturday, May 14, 2016

Add your Business to Google Maps!


Add a business/ place in Google Maps


Google Maps is a great communication app developed by Google. Millions of entities are already listed on it. But your own business may be missing here. If you'd like to add your business to Google Maps, follow this post . . . 



Necessary Tools

  • Android Phone with GPS & Data Connection
  • Google Account
  • Google Maps App
  • My Business App (Optional)

Adding your Business to Maps
  1. Get your Android Phone and turn on its GPS & Data Connection.
  2. Make sure you're signed into your Google Account and its services.
  3. Run Google Maps from your Phone.
  4. I guess you're exactly on your business spot. Make sure the location indicator is in exact position.
  5. Now click on the menu button from the upper left corner.
  6. Scroll down and choose Add a Missing Business.
  7. Add a Place > Enter your business Name, Address, Category, Phone Number, Web Address, Photos etc. 
  8. If the location indicator doesn't locate your position exactly, then you can use this option (Mark Location on Map) from address.  
  9. Make sure everything is done properly. And finally, hit on the Submit button from the upper right corner.
  10. Immediately Google will confirm your submission through email. 


Step by Step process of adding a business to Maps



Now go to the Maps again and find your business there. Write reviews and add photos of your business to make it more attractive to public. 


In my next tutorial, you will know about claiming your business . . .




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



Sunday, May 01, 2016

Got a New Phone? Clone it Easily!!




CLONEit makes easy to clone your phone

Android Devices are getting smarter everyday with new features and styles. A handset you're using today, may not use tomorrow. But you may need to get back everything from your old phone. And CLONEit is capable of importing everything from your old mobile. Got a new phone? Try it now . . . 


CLONEit Icon


About the Tool
  • Name: CLONEit
  • Category: Tool
  • File Type: APK
  • File Size: 4.1 MB
  • Developer: SHAREit Technologies
  • Offered by: Super Tools Corporation
  • 100% Free!


Features & Benefits
  • The simplest way to clone your mobile
  • 12 Types of data can be transferred including contacts, messages, apps, call logs, SMS, MMS, pictures, musics, videos and even your system settings!
  • Fast, safe & reliable
  • No computer or cable is required except the Wi-Fi network of two devices



CLONEit steps



Using CLONEit . . . 
  1. Download CLONEit from Google Play or from this link.
  2. Both of your handsets require this tool. So install it on both devices.
  3. Now run CLONEit on your old and new mobiles.
  4. On your old device, hit on the Sender button. And on your new device, hit on the receiver button.
  5. Now both of the devices will detect each other. And you've to manually select them from local device. One device will request access on another. You've to permit it.
  6. Then you've to choose the type of data to be transferred.
  7. Finally, hit on the start button to begin cloning. During the data transfer, you can have a cup of coffee. :)

Note: You can also select data of each categories. To do so, you have to click on - Click here to choose details. 



Use CLONEit with SHAREit . . .

You know what? SHAREit and CLONEit are developed by the same team. Both are the free applications from Lenovo. SHAREit has an option for phone replication. If you choose Phone replication then it will download CLONEit from Google Play

In that case, you don't need to have a different app (CLONEit) for cloning your phone! 


Phone Replicate is and Extension of CLONEit



If phone replicate plugin is already installed with your SHAREit, then it will automatically open CLEANit. Otherwise it will ask you to download from Google Play


Hope this will save a lot of time when you set up a new Android Device! 




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