The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable …

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using …

Mar 14, 2012 · Date and time to text The TEXT function in Excel converts a date or time to text in a specified format. The syntax is: =TEXT (value, format_text) Examples: Format today's date: …

Lists all Excel functions by their category, such as Logical functions or Text functions.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

It returns the entire text when searching from the front (if instance_num is positive) and empty text when searching from the end (if instance_num is negative).

The DOLLAR function, one of the TEXT functions, converts a number to text using currency format, with the decimals rounded to the number of places you specify. DOLLAR uses the …

To include text in your functions and formulas, surround the text with double quotes (""). The quotes tell Excel it's dealing with text, and by text, we mean any character, including numbers, …

In Excel, the MID function returns the specific number of characters in a string starting at the position you specify

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. …