Page 41 - Computer Class 07
P. 41
How Excel Aligns the Data Depends on What Type of Data it is?
8 Whole value : If the data is a whole value, such as 34 or 5763, Excel aligns the
data to the right side of the cell.
8 Date : If you enter a date, such as 12/16, Dec 16, or 16 Dec, Excel automatically
returns the value in your default date format (16-Dec if you haven’t changed it) in
the cell, but the Formula bar displays 12/16/2018.
8 Value with a decimal : If the data is a decimal value Excel aligns the data to the
right side of the cell, including the decimal point, with the exception of a trailing
0. For example, if you enter 246.75, then 246.75 is displayed if you enter
246.70, however, 246.7 appears.
8 Text : Excel aligns text to the left side of the cell. If the text is too wide to fit, Excel
extends that data past the cell width if the next cell is blank. If the next cell is not
blank, Excel displays only enough text to fit the display width. Widening the
column displays additional text.
Excel recognises dates when you enter them in a familiar format.
If a value displays as scientific notation (such as 1.23E+11) or number signs
(#####), it means the value is too long to fit into the cell. You need to widen the
column.
Computer-7 41