ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Convert arabic number to english text (https://www.excelbanter.com/excel-discussion-misc-queries/34549-convert-arabic-number-english-text.html)

TSK

Convert arabic number to english text
 
while printing account ihave type the number in figures and words whether
there is any function to convert the numbers into words. There is a function
called bahttext for converting into thai text. Similar funtions in english is
required

Andy Wiggins

This file might be a help:
http://www.bygsoftware.com/examples/...s/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
writing routines.

The code is open and commented.


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"TSK" wrote in message
...
while printing account ihave type the number in figures and words whether
there is any function to convert the numbers into words. There is a

function
called bahttext for converting into thai text. Similar funtions in english

is
required




Bob Phillips

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

"TSK" wrote in message
...
while printing account ihave type the number in figures and words whether
there is any function to convert the numbers into words. There is a

function
called bahttext for converting into thai text. Similar funtions in english

is
required





All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com