+ Reply to Thread
Results 1 to 3 of 3

Macro : Spelling Number Always in "Under" Position

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Macro : Spelling Number Always in "Under" Position

    hi all..

    i need your help, how to modify this macro code.
    The macro work properly but i want change result, i mean like this :
    after running code, the result is always "under" number, create new line..
    i want to result is in right position (right from number) and adding mark (.....rupiah)

    this illustration :
    number 100
    result (after running macro) is "seratus"
    my expected :
    100 (seratus rupiah)

    this attachment file.

    any hep, greatly appreciated...

    john m
    Attached Files Attached Files
    Last edited by 6StringJazzer; 11-08-2018 at 10:44 PM. Reason: Moved from Word Formatting & General

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Macro : Spelling Number Always in "Under" Position

    Change:
    Please Login or Register  to view this content.
    to:
    Please Login or Register  to view this content.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Macro : Spelling Number Always in "Under" Position

    hi macropod...
    THANK YOU!! WORKED GREAT....

+ 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. [SOLVED] how to get a position of a last number within a string e.g. "bla bla 522 to 604 bla"
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2015, 09:32 PM
  2. [SOLVED] search for a "part number" within a string and return its cell position or contents of cel
    By benakil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-24-2013, 06:37 AM
  3. Message "parametervalue.xlsx could not be found. Check spelling..."
    By ChristineM in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-20-2012, 02:19 PM
  4. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  5. How do i create macro to count number of "Y" or "N" in different worksheets
    By tehseen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2009, 12:34 PM
  6. [SOLVED] Re: macro for converting number stored as "text" (or preceeded with ') to "number" formatting
    By markx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 07:14 AM
  7. [SOLVED] macro for converting number stored as "text" (or preceeded with ') to "number" formatting
    By markx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2006, 10:20 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