convert numerical value to a text form
 

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

convert numerical value to a text form
 

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

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


"Converting number to text in Excel" wrote:


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

convert numerical value to a text form
 

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

"Converting number to text in Excel" wrote:


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

convert numerical value to a text form
 

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.

"Mike" wrote:

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

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


"Converting number to text in Excel" wrote:


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

convert numerical value to a text form
 

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 ToolsAdd-ins.

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

usage is =spellnumber(cellref)


Gord Dibben MS Excel MVP

On Mon, 9 Apr 2007 11:36:02 -0700, Varun
wrote:

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.

"Mike" wrote:

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

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


"Converting number to text in Excel" wrote:


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