Display numbers as fractions - Microsoft Support
Use the Fraction format to display or type numbers as actual fractions, rather than decimals. If no fraction format is applied to a cell, and you type a fraction such as 1/2, it will be formatted as a date.
TEXT function - Microsoft Support
Although you can use the TEXT function to change formatting, it's not the only way. You can change the format without a formula by pressing CTRL+1 (or +1 on the Mac), then pick the format you want from …
DECIMAL function - Microsoft Support
Excel supports a Text argument greater than or equal to 0 and less than 2^53. A text argument that resolves to a number greater than 2^53 may result in a loss of precision. Radix must be greater than …
Format numbers - Microsoft Support
Format numbers as dates, currency, or even fractions to cells in a worksheet. For example, if you’re working on your quarterly budget, the Currency number format shows your numbers as money.
Round a number to the decimal places I want in Excel
If you don't want unnecessary decimal places in cells because they cause ###### symbols to appear, or you don't need accuracy down to the microscopic level, change the cell format to get the number of …
Linear format equations using UnicodeMath and LaTeX in Word
Microsoft Word’s Autocorrect feature simplifies the process of typing mathematical expressions by automatically converting them into a professional format. This functionality is useful when you work in …
YEARFRAC function - Microsoft Support
This article describes the formula syntax and usage of the YEARFRAC function in Microsoft Excel. YEARFRAC calculates the fraction of the year represented by the number of whole days between …
How to enter fractions of an hour in time sheets in Small Business ...
Describes how to enter fractions of an hour for an employee in time sheets when you are using Small Business Accounting, Accounting Professional, or Accounting Express.
Convert numbers stored as text to numbers in Excel
When numbers are actually stored in cells as text, problems with calculations or sorting can occur. Read this article to learn how to fix this problem.
Create equations in OneNote using Equation Tools
Open OneNote and open or create the notebook you would like to add equations to. Select Insert > Equation, or press Alt + =. If you click the top half of the Equation button, you should get a ribbon of …
CONVERT function - Microsoft Support
Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.