FREE tutorial,solution,RSS Feeds on Operating Systems, Programming, Web Development, Applications, Databases, Networking, Hardware, Security, SEO Free Expertsforge Membership
Join us as Moderator
Submit Article to Expertsforge.com Submit Article My Expertsforge
 
RSS Feeds, Help Help RSS Feeds
bannertop
 

Excel Tutorial: Excel BAHTTEXT Function

jawahar
11/25/2007 2:49:32 PM, Views: 599
BAHTTEXT Function in Excel is used to convert a number to Thai Text with a suffix of Baht. For Example: Consider the number 1234, if this number is supplied to the BAHTTEXT Function, the output will be One thousand two hundred thirty four Baht in Thai text.

Before going to learn about the syntax of BAHTTEXT Function, there is one common question that many people ask me,
Question: "Is it possible to display the number in English Text instead of BAHTTEXT?"
Answer: "No, It is not possible. :-)"

BAHTTEXT Function Syntax:
BAHTTEXT(number)
number is the parameter that you want to convert to text, or you can also pass the reference to a cell.

BAHTTEXT Function Example:
Open an Excel sheet and goto Cell A1, and type 1234 in the cell. Goto any other cell(say B1) and type

=BAHTTEXT(A1)

Output: Displays One thousand two hundred thirty four Baht in Thai text
Next Steps:
Add this Tutorial to:
Blink Blink del.icio.ous Del.icio.us Digg Digg
Fark Fark Furl Furl Google Google
Reddit Reddit Simpy Simpy Spurl Spurl
Technorati Technorati Windows Live Win Live Yahoo Yahoo
Rate Me!
Not Yet Rated!
Rate:
Send Private MessageSend Message
Signup / Login To View the Solution or Provide Comments
Post Comment/Solution
Comment:*
        (Link Rules) 
  Use : [bold] for <b>; [/bold] for </b>; [italic] for <i>; [/italic] for </i>; [code] & [/code] for code
 
Categories
Options
Excel RSS Feed
Most Popular Tutorial
Most Popular Solution
Top Rated
Top Rankers
Overall
1. jawahar (450)
Yearly -2008
1. jawahar (50)
Expertsforge Sponsors
bnrtop