How Excel Displays Text, Numbers + Formatting (Excel Basics Part 2)

When working in Microsoft Excel, it is important to understand that what appears on the worksheet is not always the true value stored inside a cell. This lesson explains how Excel displays text and numbers, how the formula bar reveals the real contents of a cell, and how formatting tools such as wrap text, alignment, indentation and number formats control the way information appears in a spreadsheet.

Excel Basics Series

Part 1 – Understanding the Excel Interface, Worksheets + Cells
Part 2 – How Excel Displays Text, Numbers + Formatting
Part 3 – Formatting Worksheets, Borders + Visual Tools

Why Excel Shows Different Values Than You Expect

In Excel, the value stored in a cell is not always identical to what you see on the screen. Text can appear to spill into neighbouring cells even though it belongs to only one cell. Similarly, a value displayed in a worksheet may actually be the result of a formula. The formula bar reveals the true contents of the selected cell and helps confirm whether a value was typed directly or calculated from other cells.

This concept is an important part of learning Excel because many beginners assume that what appears on the worksheet is the full story.

How Text Can Extend Across Cells

When text is longer than the width of its column, Excel allows the text to extend visually into the neighbouring empty cells. Although the text appears to occupy several cells, it still belongs to the original cell where it was entered.

If another value is typed in the adjacent cell, the overflowing text becomes hidden. To confirm the contents of any cell, simply click it and check the formula bar.

Using Wrap Text to Control Cell Display

Sometimes you want long text to remain fully visible inside a single cell instead of extending into neighbouring cells. The Wrap Text command forces Excel to keep the text within the column boundaries.

When wrap text is applied, Excel automatically increases the row height so the entire value becomes visible. This feature is commonly used when working with addresses, labels or longer descriptions inside a spreadsheet.

Resizing Rows and Columns

You can adjust the size of rows and columns to make worksheet data easier to read.

The most common method is to place the cursor on the border between two row numbers or column letters and drag to change the size. Rows and columns can also be resized using the Format command in the Cells group on the Home tab, where you can manually set a specific row height or column width.

Alignment and Indentation in Excel

Excel allows you to control both the horizontal and vertical alignment of the contents inside a cell. By default, text is aligned to the bottom-left corner of the cell. Using the alignment commands on the Home tab, you can reposition the contents to create different visual layouts.

Indentation is another formatting tool that increases or decreases the space between the cell border and its contents. This is useful when organizing lists or visually separating categories of information in a worksheet.

How Excel Formats Numbers

Excel is often used to store and calculate numeric values. By default, numbers appear right-aligned within a cell. Excel can also apply different number formats such as currency, dates, times and percentages.

For example, if you type a date like “September 26 2020,” Excel may automatically convert it into a standard short date format. You can change this using the Number Format menu or select more detailed formatting options.

Controlling Decimal Places

When Excel performs calculations, the true value of a number may contain many decimal places. The worksheet may display only part of that value depending on the formatting applied.

Using the Increase Decimal or Decrease Decimal commands allows you to control how many decimal places appear in the worksheet without changing the underlying value stored in the cell.