logo elektroda
logo elektroda
X
logo elektroda
Advanced Search
logo elektroda

Converting Numeric Amount to Words in Excel for VAT Invoices

bkroy 198983 42
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
| New topic
  • #31 11215799
    AJaqubek
    Level 10  
    We have probably all cases of writing an amount in a verbal form. Everything works great, even with a simple copy it transfers the spelling formula in words.
    Thanks to everyone for your help.
  • ADVERTISEMENT
  • #32 12353633
    WarriorLite
    Level 2  
    Hello all

    The topic is thoroughly discussed, but either I missed it, or a solution independent of the computer on which we run the file has not appeared yet.

    I've had a word file in my xlstart folder for years, but when I use this file on someone else's computer, I think this feature should be integrated into the file. Which method leads to this?

    greetings
    Waldemar
  • #33 12357455
    Antidotum ex
    Level 11  
    23 Jun 2012 15:56 I added the file "Amount for text.xls" - it is enough to use the Base sheet and copy the formula. If that's not the case, it's best to send a file with an example and a description of how it should work.
  • ADVERTISEMENT
  • #34 12357518
    WarriorLite
    Level 2  
    Thanks for the answer

    I opened your file but didn't know how to use it.

    In the original version, cells b3, k10 and k11 are key for the user.

    I did so

    I copied the kq columns to my spreadsheet (to be sure, even to the same columns, although it's probably unnecessary?)

    in k10 and k11, I exchanged the reference to b3 for a cell whose value I want to verbalize. It came out zero ...
  • #35 12357893
    Antidotum ex
    Level 11  
    I think I know what's going on ... Select B3 and cut it with (ctrl + x), then paste it (ctrl + v) in a place where you have your own applet (preferably in the neighboring sheet) and your amount will be entered in numbers there. Now K10 or K11 - best to copy (ctrl + c) or cut and paste where you want the amount in words. It should work. The problem was you didn't include B3 references in L5 range references :P 7.
  • ADVERTISEMENT
  • #36 12369673
    zposp
    Level 2  
    Hello.
    I wanted to use the marek003 user function but I have a small problem. The function works without errors if the converted number has something after the decimal point (eg 56.32). Then he puts the currency in me without any problems. On the other hand, if the converted number is an integer then it doesn't put the currency into me, it works as if I used = In words (A1) and not = In words (A1; "EUR").
    I don't know what I'm doing wrong. I will mention that I tested this function on Office 2007 and 2010 and it works the same. I am asking for help in this matter.
  • #37 12415097
    jahouu
    Level 1  
    Hello,

    I am just starting my adventure with Excel - I am not an IT specialist, I do not have a strict education - I am also asking for understanding if necessary ;)

    I wanted to get the amount in words, just like marek003 developed it, but I wanted the currency to be at the end.

    In addition, somehow I solved the problem mentioned by zposp and no matter what the value is, we always have a "fraction" of pennies shown.

    Eventually it turned out to be something like this:

    Code: text
    Log in, to see the code
  • #38 12430119
    zposp
    Level 2  
    Thanks jahouu, this solution satisfies me.
  • ADVERTISEMENT
  • #39 12648031
    Pawel232323
    Level 1  
    Hello,
    could anyone change the macro added by the user jar_gogo in the file Amount offer.xls so that the amounts were translated into English. Or maybe someone has a ready macro in the format: USD 105.14 - One hundred and five USD 14/100
  • #41 16624850
    benysdz
    Level 2  
    I know that the old topic, but maybe someone managed to prevent the word "demo" from appearing before the recording?
    Thanks in advance for your answer :)
  • #42 16625049
    Prot
    Level 38  
    He has been using his own user functions successfully for many years:
    Code: VBScript
    Log in, to see the code

    which converts the number eg 794.60 - into an expression like "In words: seven hundred and ninety-four zlotys and sixty groszy".

    based on the nabla.xla sheet - download :D
  • #43 17537463
    sever321
    Level 11  
    RadekS wrote:
    maybe a bit late, but it's better than never ;)
    I attach a file with a description and a file,
    which converts numeric values to "in words"
    It really makes life easier! :)

    The file "Slownie.xls" should be copied to the folder [drive]: \ Microsoft Office \ Office \ XLStart. After this procedure, each time the sheet is opened, a new function will be available (WORDS.XLS! Words ()) in "Paste function / Function category: / User". After calling the function, enter directly the number in the "argument" field or indicate the cell from which the argument will be taken.


    How do I run this macro?
    I do according to the instructions. When opening Excel, a message pops up whether I want to run a macro, but basically nothing happens.
    when it comes to programming I am a layman so please be understanding.
    What is the argument mentioned by RadekS?
    There is no "word" in "Paste function".
    OKAY. I got it.

    Thanks
| New topic
Report a violation of the law

Topic summary

The discussion revolves around converting numeric amounts to words in Excel, particularly for generating VAT invoices. Users share various methods, including using macros, user-defined functions, and external files. A commonly referenced solution involves a macro that can be integrated into Excel, allowing users to convert numbers into words with currency formatting. Several users provide links to resources, share their own macros, and discuss the functionality of existing solutions. Issues such as displaying currency correctly and ensuring compatibility across different Excel versions are also addressed. Users express a need for solutions that do not require VBA and can be easily implemented in their spreadsheets.
Summary generated by the language model.
ADVERTISEMENT