number to words

Good morning vjn

...and welcome to the forum!!

Download and install my add-in from the link below.
Once installed go to Ultimate > Formulae > Add Function and select SpellNumber from the list and click on Add Function.

This will add a macro to your workbook that can be used as a custom functions.
If cell A1 contains the value 1234.56 then :
=SpellNumber(A1)
would return :
One Thousand Two Hundred and Thirty Four Pounds and Fifty Six Pence

Currency is optional, but currently supported is GBP, EUR, USD and Indian Rupees.

HTH

DominicB

Try this code, place it in a Standard Module.

Please Login or Register  to view this content.

You can use in a cell like this, in A1 place your number, then in B1 type = SpellNumber(A1)