Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GOURI
 
Posts: n/a
Default HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT()?

HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT() FUNCTION
AS IT IS DISPLAYED IN BHAT FORMAT.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
display a number that is decimal degrees in Deg:min:sec format Sterling Excel Discussion (Misc queries) 1 December 18th 05 12:50 AM
Master invoice number Christopher M. Excel Worksheet Functions 0 July 24th 05 04:26 PM
Convert arabic number to english text TSK Excel Discussion (Misc queries) 2 July 9th 05 10:24 AM
How do I multiply Column G Totals by a number and display the res. wewgyro Excel Discussion (Misc queries) 2 December 5th 04 04:27 PM
Combine & Display “Fixed” & “Automatically Updated” Date Parts texcel Excel Worksheet Functions 1 November 1st 04 05:38 PM


All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"