ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT()? (https://www.excelbanter.com/excel-worksheet-functions/61927-how-display-number-into-english-using-bahttext.html)

GOURI

HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT()?
 
HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT() FUNCTION
AS IT IS DISPLAYED IN BHAT FORMAT.

Arvi Laanemets

HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT()?
 
Hi

BAHTTEXT() is somewhat a unique function. Read more at
http://www.j-walk.com/ss/excel/odd/odd20.htm

For us rest of world, we must use UDF's. The easiest way to find one for
english language, is to search in MS Knowledge Base for phrase "number to
words" or somethihg like this.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"GOURI" wrote in message
...
HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT() FUNCTION
AS IT IS DISPLAYED IN BHAT FORMAT.




Bob Phillips

HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT()?
 

"Arvi Laanemets" wrote in message
...

For us rest of world, we must use UDF's. The easiest way to find one for
english language, is to search in MS Knowledge Base for phrase "number to
words" or somethihg like this.


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




All times are GMT +1. The time now is 08:22 AM.

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