## Featured post

### Office 2013 Activator (KMSpico 9.1.3)

KMSpico 9.1.3 is really an amazing tool for activating Office 2013. And as a bonus, you can also activate Windows 8 or 8.1 with thi...

### Converting Numbers into Words in 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.
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.

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.

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!

### Use Hue/ Saturation to Modify Color in Photoshop

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)

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

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

Example 2

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

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.

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

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

Necessary Tools
• Android Phone with GPS & Data Connection
• Browser (I prefer Google Chrome)

3. Tap on your business and it will prompt you to a new window.
4. Choose the option - Claim this business.
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!

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!

Necessary Tools

• Android Phone with GPS & Data Connection

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.
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.
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.

### Got a New Phone? Clone it Easily!!

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 . . .

• 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

Using CLONEit . . .
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!