Data Types

To change the data type of a cell (or region):

  1. Right click > Format Cells…
  2. Select the category and type for the data type (ie – catergory Date and type dd/mm/yyyy)

image004

Cells with Numbers

There are shortcuts on the toolbar that may help you save time:

  • For decimal numbers use the rounding buttons
  • For percentages use the percent button

image006

Cells with Dates

Sometimes when copying dates they appear as numbers (ie – 40179). The reason for this is at copy time the cell has been set to display data as a number and not a date. To correct simply change the data type to Date (explained above).

Cells with Text

Cells that contain text have different behaviour to those that contain numbers:

They automatically overlap empty adjacent cells to the right (the text belongs to cell in the J column below).

image008

If the adjacent cells to the right contain text it doesn’t overlap and shrinks out of view.

image010

There are two ways to correct this:

1. Double click the column divider to “Fit column to size”.

image012

OR

2.  Format the cell to “Wrap Text”. Rick click > Format Cell… > Alignment (tab) > Wrap Text

It should now appear in the J column as should below:

image014

Leave a Comment