convert numerical value to a text form

[Guest]

i like to convert the number say USD.250/- to US Dollars Two Hunderd and
Fifty only . How Can I Do This Function in Excel > I tried the Formula
=Bahttext(250) but it comes in some other language

 

[Guest]

This function courtesy of Microsoft re-published below seems to be the
favoured option.

http://www.ozgrid.com/VBA/ValueToWords.htm

 

[Guest]

BAHTTEXT() converts to Thai so it won't be

 

[Guest]

Hi,
I tried it and it really works. Going a step forward, I want to be able to
use this function for all new workbooks which I am going to create in future.
How can I do this, pls reply.

Thanks in anticipation.

 

[Gord Dibben]

Varun

Stick the code into your Personal.xls workbook so's it will be available for all
open workbooks, existing and new.

usage would then be =Personal.xls!spellnumber(cellref)

Or create a workbook, add the code then save as an Add-in which you can load
through Tools>Add-ins.

Then you don't have to preface with the workbook name.

usage is =spellnumber(cellref)


Gord Dibben MS Excel MVP