Excel Tutorial – BAHTTEXT

The BAHATTEXT function in Microsoft Excel is a financial function that converts a number to text in Thai Baht currency format.

Here’s a step-by-step guide on how to use the BAHATTEXT function:

1. Open your Microsoft Excel spreadsheet and select the cell where you want to display the converted number.
2. Type the following formula into the selected cell: =BAHTTEXT(number)
3. Replace “number” with the cell reference or value that you want to convert to Thai Baht currency format.

For example, if you want to convert the value in cell A1 to Thai Baht currency format, the formula would be: =BAHTTEXT(A1)

4. Press Enter to complete the formula and display the converted value in Thai Baht currency format.

Note: The BAHATTEXT function is only available in Excel for Office 365 and Excel for the web.