Skip to content

← Using a Computer, in Practice

Spreadsheets · 62 of 111

Fix ##### and numbers that won’t add

Not tested on its own

Do this

  1. See #####? Double-click the line between the column letters at the top. The column widens.
  2. Total looks too small? Look at how your numbers sit in the cell. Numbers go to the right. Text goes to the left.
  3. For a number on the left, click the cell, and look for a space or a letter in it, like 85 or Rs 85.
  4. Retype it as a plain number.

Want “Rs.” to show? Use a currency format, rather than typing it in.

Why this way

A sum quietly skips text, with no warning, so a total can be wrong while looking right. It often happens with numbers pasted from a website or PDF. Check a total by adding a few rows yourself. Plain know-how.

Do it today

Type 85 with a space in a column of numbers, and see what SUM does. Two minutes.

Where these facts come from
  • Everyday know-how, written without a help page to check it against. If a menu here has changed, please tell us.

General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.

← All 111 things to do