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.
TEXT function - Microsoft Support
It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. Note: The TEXT function converts numbers to text, …
Round a number to the decimal places I want - Microsoft Support
Round a number to the decimal places you want by using formatting and how to use the ROUND function in a formula to round to the nearest major unit such as thousands, hundreds, tens, or …
QUOTIENT function - Microsoft Support
This article describes the formula syntax and usage of the QUOTIENT function in Microsoft Excel. : If you want to divide numeric values, you should use the "/" operator as there isn't a DIVIDE …
Format numbers as currency - Microsoft Support
You can display a number with the default currency symbol by selecting the cell or range of cells, and then clicking Accounting Number Format in the Number group on the Home tab. (If you …
Stop automatically changing numbers to dates - Microsoft Support
Stop Excel from entering dates automatically by changing numbers to dates. You can format cells as text before you enter numbers. Or if you have just a few numbers to work with, enter a …
FLOOR function - Microsoft Support
This article describes the formula syntax and usage of the FLOOR function in Microsoft Excel. Rounds number down, toward zero, to the nearest multiple of significance. FLOOR (number, …
Add or change data types (Power Query) - Microsoft Support
Power Query reads the table schema from the data source and automatically displays the data by using the correct data type for each column. Unstructured sources Examples include Excel, …
Create a drop-down list - Microsoft Support
You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
Format numbers as percentages - Microsoft Support
To quickly apply percentage formatting to selected cells, click Percent Style in the Number group on the Home tab, or press Ctrl+Shift+%. If you want more control over the format, or you want …
Explode or expand a pie chart - Microsoft Support
To make parts of a pie chart stand out without changing the underlying data, you can pull out an individual slice, pull the whole pie apart, or enlarge or stack whole sections by using a pie or …