Excel Convert Data English to Hindi

 

Why we need to change the version or languages? Very simple because of your Boss’s instruction and nowadays Excel is being used in Indian Local Market so sometimes it is necessary to provide reports in a convenient language (Hindi in India). As you know the MS-office does not provide the option to write in Hindi or any other languages. So where do we go let’s read the articles carefully.

First of all we need to open Google Sheet in our browser.

We have to log into our Google Account.

and click on Blank

After that Copy Data in English from your source Excel sheet & paste it in Google Sheet and Apply Formula

=GOOGLETRANSLATE(C3,"EN","HI")

Here in my file - 'C3' is source data cell.

                          - 'EN' is from language. (Type EN for English)

                          - 'HI' is destination language (Type HI for Hindi) 

Press Enter and you will get a result.

Copy All Hindi Data From Google Sheet and Paste it in Your Excel File.

For more Visit My Blog

Thank You

Convert an Amount from Numerics to Word (Indian Rupees) in Excel 2010

"NumtoRupees" Indian Rupees Function is an Excel function manually created with VBA code to change a given Amount to written words in Indian Rupees along with paise. In other  words it converts "₹" in to "INR".

This function is not a inbuilt function to display the numeric value in words.

So we are going to create this function. 

First of all you have to click on this LINK this will open a new tab containing a file see in picture below.

1. Click on file and Press Ctrl+A (select all) and Copy All by pressing Ctrl+C.

2. Go to Desktop -----> Right Click on Desktop -----> New -----> Microsoft Excel Worksheet. (See in Picture below)

See there is a file on Desktop, Give a Name to this file and open it.

3. After open this file press Alt+F11 for open VB File window and go to Insert ---->Module.

4. In this next Module code file Paste code by pressing Ctrl+V.

5. After doing step no. 4 press Ctrl+S for save Module.

This is will be save as a Macro enabled workbook so click on YES for continue. (See Picture Below)

6. Save excel file. and Click on OK.

Congratulations !!

Your File is ready to use..

Ok Let's use this file with in example.

--> Create a column containing some numbers from B3 to B24.

--> use formula in cell C3 =NumtoRupees(B3).

And Press ENTER.

See the formula is working. 👇

Thanks for Learn with me.

How to Upload files in Google Drive in Mobile Device.

Are you worry about your files security...?

Nowadays, users are worried about the security of files in their mobiles, for which they use some third party applications, but it is not right to rely on these applications.  Cloud storage is considered the best option for this nowadays.  So today we will talk about one such cloud storage "Google Drive", How to securely upload your files in Google Drive..

Let's understand this with the help of pictures.

Steps for create a new folder and upload a file in it..

Step 1

    Open "Google drive" from menu.

Step 2

    Tap on "+" sign botton right side on screen.

Step 3

    Select "Folder" option from menu.

Step 4

    Give a name to your folder & tap on "Create" option.

Your folder has been created on screen as shown in picture below

Tap on folder to upload files in this folder and repeat Step 2 Again.

Table of Figure

👉 Step 1

👉 Step 2

👉 Step 3

👉 Step 4

👉 Result

---------------------------------------*************------------------------------------