Convert Numbers into words automatically in MS Excel

Discussion in 'Apps & Software' started by sor, Jul 29, 2020.

  1. sor

    sor
    uix_expand uix_collapse
    New Member

    Joined:
    Jul 2, 2020
    Messages:
    1
    Likes Received:
    0
    I use MS Excel to print bills of my company, it is simple with tables, formulas, etc. Now I have problem with converting total rupees to words automatically. I have seen some solutions, but they work only when there are only numbers in that cell.

    In my case I have symbol of rupees in that cell and I want that symbol as well as it should convert the numbers to words in automatically. Please help it saves a lot of time for me.
     
  2. fisicx

    fisicx
    uix_expand uix_collapse
    Active Member
    Community Liaison 1.0

    Joined:
    Mar 3, 2016
    Messages:
    2,626
    Likes Received:
    217
    Please post a link to the solution you have found.

    I suspect you will need to strip the word 'rupee' or symbol from the cell, do the conversion and then add the symbol back in.
     
    • Agree Agree x 1
  3. VITS USA

    VITS USA
    uix_expand uix_collapse
    Member

    Joined:
    Aug 20, 2018
    Messages:
    878
    Likes Received:
    66
    How is your format? Otherwise you can add column heading as a RS., after that you will have not required rupee sign multiple times.
     

Share This Page