+ Reply to Thread
Results 1 to 7 of 7

convert amount in word

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    convert amount in word

    Hi their, this is the amount 236450 , I want to convert it like that "TWO LAC THIRTY SIX THOUSAND FOUR HUNDRED FIFTY ONLY"
    this is only example i want every amount which i entered convert in to word
    so please give me formula or vba code

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: convert amount in word

    Here is an example of what you are trying to achive more or less:

    https://support.microsoft.com/en-us/...words-in-excel

    https://www.extendoffice.com/documen...-to-words.html

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: convert amount in word

    See here:

    http://quadexcel.com/how-to-convert-...at-vba-macros/

  4. #4
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: convert amount in word

    hello john topley your solution is fine working, but one small change i want in that , this "RUPEES" word appearing in starting i dont want that word, so how can remove this word in VBA code please tell me.

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: convert amount in word

    Try this
    Change this line
    Please Login or Register  to view this content.
    as
    Please Login or Register  to view this content.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  6. #6
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: convert amount in word

    Thanks Mr. kvsrinivasamurthy

  7. #7
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: convert amount in word

    i want some change in that VBA code which you provided, i want that where is decimal value is equal or greater than 0.50 then round up that value to one

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert Word 2007 macro to work in Word 2003
    By kamaflage in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2015, 10:30 AM
  2. Replies: 3
    Last Post: 08-04-2013, 09:40 PM
  3. Convert Word to Excel based upon Word Table of Contents
    By jcappuccino7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2013, 01:25 PM
  4. How to convert amount in to word
    By shaileshgavanang in forum Excel General
    Replies: 0
    Last Post: 06-26-2012, 02:48 PM
  5. Replies: 2
    Last Post: 12-29-2005, 07:20 AM
  6. Convert a column in Amount in Word
    By Chandan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-12-2005, 01:06 PM
  7. Replies: 1
    Last Post: 05-10-2005, 07:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1