You are here:

Microsoft Word/Continuation of question asked

Advertisement


Question
Sir, this is in continuation to my question asked here: http://en.allexperts.com/q/Microsoft-Word-1058/2015/7/excel-vba-word.htm

The question remain exactly the same except that the number of digits to convert is only 4 digits before and 3 digits after the decimal(point) in following style:

1234.123 should be convert as Twelve crore thirty four lakhs twelve thousand three hundred.
123.12 should be convert as one crore twety three lakhs twelve thousand.
12.1 should be convert as Twelve lakhs ten thousands
1.001 should be convert as one lakh one hundred

Naming of number After decimal:
Unit place will be called hundred
Tens place will be called thousand
Hundred place will be called Ten thousand

Naming of number Before decimal:
Unit place will be called Lakh
Tens place will be called Ten Lakhs
Hundred place will be called Crore
Thousand place will be called Ten crore

Please provide a macro to accomplish above requirement.

Answer
The macro I gave you already should largely do this - it appears the only change you want is to remove the words rupees and paise from the amount after the decimal point - at which point this entire section can be removed:

Select Case Rupees
 Case ""
     Rupees = "(No Rupees"
 Case "One"
     Rupees = "(One Rupee"
 Case Else
      '****************************************************************
      'Rupees = Rupees & " Rupees"
     Rupees = "(Rupees " & Rupees
      
 End Select
 Select Case Paise
 Case ""
'****************************************************************
     Paise = ") Only"
 Case "One"
     Paise = " and One Paisa"
 Case Else
     Paise = " and " & Paise & " Paise) Only"
      
 End Select

Apart from that, the macro should work as expected

www.flameenterprises.co.uk support@flameenterprises.co.uk
About Microsoft Word
This topic answers questions related to Microsoft Word stand-alone or Microsoft Office Word including Word 2003, Word 2007, Office 2000, and Office XP. You can get Word help on formatting text, tables, tabs, fonts, styles, general Word layouts, bullets, headings, and outlines, using templates, toolbar modifications, and using Track Changes. You may also find tips on linking Word and Excel embedded objects including charts. This site does not provide a general Word tutorial nor the basics of using a word processor. It provides specific answers to using Microsoft Word only. If you do not see your Word question answered in this area then please ask a Word question here

Microsoft Word

All Answers


Answers by Expert:


Ask Experts

Volunteer


Aidan Heritage

Expertise

I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions of Word from 2 onwards

©2016 About.com. All rights reserved.