| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| how to convert numerical figure into text | Excel Worksheet Functions | |||
| HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT | Excel Worksheet Functions | |||
| How do I convert numerical into words ? | Excel Discussion (Misc queries) | |||
| Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) | |||
Linear Mode
