CHAR Function

Description The CHAR function returns the character specified by the code number. Syntax CHAR(number) Parameters Number Required. A number between 1 and 255 specifying which character you want. The character is from the character set used by your computer. Examples The example may be easier to understand if you copy…

BAHTTEXT Function

Description The BAHTTEXT function converts a number to Thai text and adds a suffix of “Baht.” Syntax BAHTTEXT(number) Parameters Number Required. A number you want to convert to text, or a reference to a cell containing a number, or a formula that evaluates to a number. Examples The example may…

ASC Function

Description For Double-byte character set (DBCS) languages, The ASC function changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters. If you want to change half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters, please use WIDECHAR function. Syntax ASC(text)…

How to Quickly Extract Pictures From An Excel File

If you want to quickly extract pictures from an Excel file that embedded many pictures, you cannot be simply to do this. There’s no build-in function to do this in Excel. Here are two simple ways to quickly extract pictures from an Excel file. 1. Open your Excel file, click…

How to Sum Data in Excel

There are many ways to sum data in an Excel spreadsheet. For example, if you want to sum the values in cells A1:A5, how to do it? 1. Select cells A1:A5, and you will see the sum results in the status bar. 2. Select cells A1:A5, press and hold ALT,…

Formatting a Range of Cells In Excel VBA

Formatting Cells Number General Range(“A1”).NumberFormat = “General” Number Range(“A1”).NumberFormat = “0.00” Currency Range(“A1”).NumberFormat = “$#,##0.00” Accounting Range(“A1”).NumberFormat = “_($* #,##0.00_);_($* (#,##0.00);_($* “”-“”??_);_(@_)” Date Range(“A1”).NumberFormat = “yyyy-mm-dd;@” Time Range(“A1”).NumberFormat = “h:mm:ss AM/PM;@” Percentage Range(“A1”).NumberFormat = “0.00%” Fraction Range(“A1”).NumberFormat = “# ?/?” Scientific Range(“A1”).NumberFormat = “0.00E+00” Text Range(“A1”).NumberFormat = “@” Special Range(“A1”).NumberFormat…