+ Reply to Thread
Results 1 to 13 of 13

Numbe to word without the word " Rupee"

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Numbe to word without the word " Rupee"

    Hi
    I thank the forum wholeheartedly for the immense and timely help you have rendered.
    I require one help
    we indend to use the attched the code for cheque printing purpose through excel.
    However I request code without word rupee
    say
    1000
    it spells "One thusand and paise zero only"
    I request a correction in the code
    a) No rupee is appearing
    b) only when decima is entred it should spell and paise
    c)It shoudl not add paise for amount entered in whole number.

    Please help me out in this regard.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    43,754

    Re: Numbe to word without the word " Rupee"

    Please post the code that needs updating.
    Last edited by AliGW; 07-13-2019 at 03:20 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: Numbe to word without the word " Rupee"

    i am ubale to post by reply

  4. #4
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: Numbe to word without the word " Rupee"

    i am getting firewall as if my id is blocked

  5. #5
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: Numbe to word without the word " Rupee"

    I am unable to do any atachment.
    I am getting blocked by sukuri website firewall
    Pls guide me
    Attached Files Attached Files
    Last edited by srinivasan1965; 07-13-2019 at 11:04 AM.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    43,754

    Re: Numbe to word without the word " Rupee"

    If you are unable to post the code, then attach a workbook that contains the code.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

  7. #7
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: Numbe to word without the word " Rupee"

    Hi
    I have done attachment Please help me
    Thanks
    Srinivasan
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: Numbe to word without the word " Rupee"

    Hi
    Anybody can help on this please
    Srinivasan

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    43,754

    Re: Numbe to word without the word " Rupee"

    What is the password for the worksheet, please?

  10. #10
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: Numbe to word without the word " Rupee"

    Hi
    I am very sorry
    password is srini

  11. #11
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: Numbe to word without the word " Rupee"

    Hi all
    Any help on this please

  12. #12
    Forum Contributor
    Join Date
    11-12-2012
    Location
    Jeddah, Saudi Arabia
    MS-Off Ver
    2010, 365
    Posts
    300

    Re: Numbe to word without the word " Rupee"

    I guess this is what you wanted.
    Attached Files Attached Files

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    43,754

    Re: Numbe to word without the word " Rupee"

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

+ 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] extract text :keep the word in front of "apple", after "apple" delete all word
    By hktom in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-03-2018, 11:20 AM
  2. [SOLVED] after copy excel to word, how to prompt "save as" for word
    By toronto1999 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-23-2016, 10:37 AM
  3. [SOLVED] Need to Find All Cells Containing "Word" and Replace With "Other Word" from Cell Below?
    By notsmart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2016, 09:00 AM
  4. [SOLVED] (Challenge) Sum Order From Count "Center" Word To Start Word & "Center" Word To End Word
    By sanju2323 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-31-2015, 12:58 AM
  5. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  6. [SOLVED] If a cell contains a "word" (within other words) then enter a "word"
    By jtmann in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-19-2013, 02:20 PM
  7. [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

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