+ Reply to Thread
Results 1 to 1 of 1

Spell Numbers code change needed

  1. #1
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    Spell Numbers code change needed

    I need help in 2 things in the attached file:-
    I've got the number to text code from Microsoft site and I've changed a little as my need, and as much as I can.

    But I still need help to show the decimal as "123/1000" instead of "one hundred twenty three Fils"

    second thing, since I must follow the form in the attached file, I've separated the number 1234.567 to be in two columns (one for dollars and other for cents).

    But the VBA code can't Sum the Total from the 2 columns, so I made a separate cell for total but for sorry it SUM the numbers not combine them.

    * I hope my post not breaking any forum's rules
    Attached Files Attached Files
    Last edited by nasser; 11-27-2012 at 01:11 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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