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
   36   37   38   39   40   41   42   43   44   45   46