Excel Function : BAHTTEXT

Download now!

Excel Function : BAHTTEXT

Category

Text

Description

Converts a number to text, using the ß (baht) currency format

Microsoft Excel Reference Page

https://support.office.com/en-us/article/BAHTTEXT-function-5ba4d0b4-abd3-4325-8d22-7a92d59aab9c

Syntax and Description of the BAHTTEXT Excel Function

. =BAHTTEXT(A1) Where: A1 = reference to the cell with the numeric value. How to use the BAHTTEXT function in Excel? BAHTTEXT function comes in handy when you want to convert a numeric value into text. The function can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, BAHTTEXT can be entered as a part of a formula in a cell of a worksheet. For example, let us say you want to convert the value 1500 into Thai Baht. The following formula would do the trick: =BAHTTEXT(

About BAHTTEXT Excel Function

The BAHTTEXT function converts a numeric value into text in the Thai language using the ß character to represent a decimal point. For example, the number 123456.78 would be converted to หนึ่งล้านสองแสนสามหมื่นสี่พันห้าสิบหกบาทเจ็ดสิบแปดสตาง