Excel Tricks

Saturday, 31 August 2019

Bahttext function in Excel

Bahttext is a function that converts a number to Thai Baht text with a suffix "Baht".

Syntax of Bahttext function is

=BAHTTEXT(number)



From two example it is very clear that "Bahttext" function only converts a number. If we enter a text then it gives an error "#VALUE". 
Posted by Santosh Choudhury at 11:13
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

My photo
Santosh Choudhury
View my complete profile

Pages

  • Home

Labels

Reverse Column in Excel Reverse Order in excel Reverse Row in Excel searching text

Blog Archive

  • ►  2021 (1)
    • ►  April (1)
  • ▼  2019 (22)
    • ►  September (6)
    • ▼  August (16)
      • Bahttext function in Excel
      • Upper Function in Excel
      • Proper function in Excel
      • Lower Function in Excel
      • Trim Function in Excel
      • Clean Function in Excel
      • Named Ranges in Excel
      • Add Drop-down in Excel
      • Summation of every 3 (Quarterly) values of cells.
      • Offset Function in Excel
      • Use Of Wildcards in Excel
      • Finding Text in Multiple Columns
      • Reverse Order of Columns and Rows in Excel
      • Conditional Formatting Example with Formula
      • Reverse The String In Excel
      • Remove Any Number of Characters From String In Excel
Simple theme. Theme images by gaffera. Powered by Blogger.