Convert Number to Words in Indian Currency Format in Excel 2010

In this article, we will learn on how to convert number to words in Indian currency format in excel

If you have data consisting of amounts which are formatted to show in dollars ($) and you would like to show it in the Indian Rupee format, the steps below will help you.

    • Select the cells &right click on the mouse.

 

img1

 

    • Click on Format Cells orPress Ctrl+1 on the keyboard to open the Format Cells dialog box.

 

img2

 

    • Select the Number tab, and from Category, select Currency.

 

img3

 

    • Click on the Symbol Drop Down Menu.

 

img4

 

  • Select English (India) as the Currency symbol. This is how the result looks in cell A1

 

img5

 

You can also use the Custom Formatting option to convert numbers to Words in the Indian Currency Format.

Steps for Custom Formatting:

  • To go to Format Cells, press Ctrl + 1 shortcut key on the keyboard.
  • Select the Number tab, and from Category select Custom.
  • In the Type box, enter the Custom Formatting syntax which is ? #.
  • Click on Ok.

Let us see a few examples to understand how this works -
Example 1

We have entered “100” in a cell. After applying the Custom Formatting syntax as explained above, we get the output as shown -

Let us see a few examples to understand how this works -
Example 1

We have entered “100” in a cell. After applying the Custom Formatting syntax as explained above, we get the output as shown -

 

img6

 

This is how our output looks -

 

img7

 

Example 2

We enter “100” in a cell and after applying Custom Formatting for Decimal points, using the syntax ? #.00 we get – (see screenshot)

 

img8

 

This is how our output looks –

 

IMG9

 

Example 3

We enter “10000” in a cell and after applying Custom Formatting, we can convert the number to ?10 k format as ? #, k see screenshot:

 

IMG10

 

This is how our output looks -

 

IMG11

 

Thus, you can create your own customized formats as per your requirements.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube