1. Numeric Data
In Excel, numeric data includes numbers from 0 to 9 and data containing any symbol such as positive sign, negative sign, currency symbol, percent sign, etc. By default, numbers are aligned to the right side of the cell.
2. Numbers as General Type
When number text is entered, Excel treats it as numeric type, and the display becomes right-aligned, although the current cell data type is still shown as
Note that when inputting:
General.Note that when inputting:
(12.345), Excel will automatically convert the cell content to: -12.345.3. Numbers with Commas
When the input number text includes a comma
, , Excel saves it in Number format.4. Numbers with Currency Symbols
When the input number text contains a currency symbol, such as:
There can be spaces between the currency symbol and the number.
If there is an error in the currency value, Excel will highlight it in red for us.
$, Excel saves it in Currency format.There can be spaces between the currency symbol and the number.
If there is an error in the currency value, Excel will highlight it in red for us.
5. Numbers with Percent Signs
When the input number text ends with a percent sign
%, Excel saves it in Percentage(Percentage) format.6. Inputting Fractions with 0 + Space at the Beginning
If we want to input a fraction, directly inputting
We can also precede the fraction with a 0 and a space, which will also be correctly recognized as a fraction.
1/2, Excel will typically interpret it as a date. In this case, we can set the cell to fraction format in advance and then input it.We can also precede the fraction with a 0 and a space, which will also be correctly recognized as a fraction.
7. Long Numbers
When inputting a number text greater than 11 digits, Excel will convert it to scientific notation, saving it in
Note that Excel supports a maximum of 15 digits. If the number exceeds 15 digits, the digits beyond the 15th will be stored as zero.
For numbers exceeding 15 digits, it is recommended to save them in
Scientific format.Note that Excel supports a maximum of 15 digits. If the number exceeds 15 digits, the digits beyond the 15th will be stored as zero.
For numbers exceeding 15 digits, it is recommended to save them in
Text format.8. 🎉 Finish! 🎉
Author's Note: I hope you can feel the effort I put into these tutorials. I hope to create a series of very easy-to-understand Excel tutorials.If it is useful, help me share these tutorials, thank you!
Follow me:
Related Tutorials