← Using a Computer, in Practice
Spreadsheets · 62 of 111
Fix ##### and numbers that won’t add
Not tested on its own
Do this
- See
#####? Double-click the line between the column letters at the top. The column widens. - Total looks too small? Look at how your numbers sit in the cell. Numbers go to the right. Text goes to the left.
- For a number on the left, click the cell, and look for a space or a letter in it, like
85orRs 85. - 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.
