I am trying to implement the formula from here into microsoft word. It is working in excel but I always get Syntax Error (xxx) in microsoft word though. I tried looking everywhere on the web but still cant figure out how to do this in microsoft word,anyone can lend a hand? Really appreciate it!

Works perfectly for me.

And I get:

Two Hundred Thirty Four Dollars And Fifty Six Cents

I did have to carefully clean up the copy and paste from that web page. It added a whole bunch of spaces. But the code works in Word. There is no syntax error in the code itself. If you are getting one there is something wrong with the text you are using.

Can i know what is that code you posted for? And i thought spaces doesnt matter in code? Sorry still new at this x.x

I tried added that code of yours to the end of the code from that page, then i tried to run macro,and it works!! but how do I make it convert any numbers i want without keep changing the numbers in module?Thanks!

I put this code in the module :


Then i go to word,create a table, and insert this:


But all i get is this:


Can i know how to make it work? I tried to use your code and yes it works but everytime i want to convert a different number I have to edit the code. Is there anyway simpler? This is intended for my mother for her work, and I doubt she can remember all the steps to go into the code and edit it everytime.

kahheng93: Please don't post multiple screenshots. If you want to post:
• code, post that (using the code tags on the advanced page)
• error messages, post those as text.
For a Word-based macro to convert numbers to text, see: http://gregmaxey.com/word_tip_pages/..._currency.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

noted, wont happen again. i tried the link,first method do not allow me to edit the words such as 'dollars' ; second method has compile error syntax error when trying to run ; third method has errors when running the add-ins suchs as : "Could not load an object because it is not available on this machine" or "Compile error in hidden module" or macro cannot be found or has been disabled because of your macro security settings". I tried enabled all macros in trust center and trust access to vba project object model... nothing works so far... x.x

Microsoft’s ‘DollarText’ field switch doesn’t allow you to specify anything other than dollars. It also doesn't express a value as ‘X dollars and Y cents’ – it returns ‘X and Y/00’. Here’s a field code that takes a more sophisticated approach that allows you to change the currency and use much greater values:
With this field you can go all the way to 999,999,999.99 (technically you could go two orders of magnitude higher). You can omit/edit the:{=INT(Val) \# \dollar;;}{IF{=INT(Val)}> 1 "s"} and {IF{=MOD(Val,1)}> 0.01 cents cent}"}portions if you want no/different currency. You could likewise omit the various tests for inserting 'and ', if you prefer.

Note: The field brace pairs (ie '{ }') for the above example are created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message.

You could also use a macro to convert the above to a working field. For that, see: http://www.gmayor.com/export_field.htm#TextToField
That solution is designed for working with formfields only. Does your document contain the required formfields - with the required names?
Did you install the correct version, as per the instructions given on that site?
None of that should be necessary; indeed it opens your PC to macro virus attacks.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]