Entering and editing data the right way
Learn the difference between text, numbers and dates, how to type and edit quickly, and how to lay data out so Excel can work with it.
In this lesson you will
- Tell text, numbers and dates apart
- Type, edit and autofill quickly
- Spot numbers stored as text
- Lay out data as a clean table
About 14 minutes
Why does my total not add up?
Karan types the marks of his class into a sheet and asks Excel to add them. The total is lower than it should be. He checks the numbers again and again: they all look right. The problem is invisible: three of the marks were pasted from a website and Excel is treating them as text, not numbers. This lesson is about entering data so that Excel understands it, and about the habits that save you from these quiet problems.
Three kinds of entries
| Kind | Examples | Default alignment |
|---|---|---|
| Text | Notebook, Delhi, Rs 123 | Left |
| Numbers | 40, 3.5, -20 | Right |
| Dates and times | 5/3/2026, 14:30 | Right |
The alignment is a handy clue. If a number sits on the left of its cell, Excel is probably treating it as text. The sheet below was really recalculated to check this. A1 holds the number 123, A2 holds ‘123’ stored as text, and A3 holds the words ‘Rs 123’:
| Cell | Test | Result |
|---|---|---|
| A1 | =ISNUMBER(A1) | True |
| A2 | =ISNUMBER(A2) | False |
| A3 | =ISNUMBER(A3) | False |
Now add them: =SUM(A1:A3) gives 123. Only the true number was added. SUM quietly ignores text, which is exactly how Karan’s total came out too small.
Dates are numbers in disguise
Excel stores each date as a number: the count of days since a starting date. The first of January 2026 is stored as 46023 and the second as 46024, so the difference between them is 1 day. This is why you can subtract dates to count days. It also means a date cell must be recognised as a date: type it in the format your computer uses (for example 5/3/2026 or 5-Mar-2026) and Excel will convert it.
Day-month-year or month-day-year? It depends on your computer’s regional settings, so check by typing a date such as 13/1/2026. If Excel keeps it as text, your computer expects month first.
Typing and editing
- Click a cell and type. Press Enter to accept and move down, Tab to move right, or Esc to cancel.
- To change a cell, select it and press F2 (or double-click). Retyping over a selected cell replaces it.
- To clear a cell, select it and press Delete.
- To undo a mistake, press Ctrl+Z; to redo, Ctrl+Y.
Saving time while typing
- Autofill: type Monday, then drag the small square at the cell’s bottom-right corner (the fill handle). Excel continues with Tuesday, Wednesday … Months, numbers and dates work too.
- Series from two cells: type 10 and 20, select both, and drag the handle to continue 30, 40, 50.
- Copy and paste: Ctrl+C, then Ctrl+V. Use Ctrl+X to move.
- Ctrl+Enter: fill the same entry into every selected cell at once.
Laying out data so Excel can work with it
A good data sheet is a plain table. Follow these rules and sorting, filtering, charts and formulas will all work smoothly later:
- One header row at the top, with a short name for each column.
- One record per row (one sale, one student, one expense).
- One kind of thing per column (all dates in one column, all amounts in another).
- No blank rows or columns inside the table.
- Do not put totals in the middle of the data; keep them to one side or below.
- Do not merge cells inside the data.
Spelling and spaces count
To a computer, ‘Delhi’, ‘Delhi ‘ (with a space on the end) and ‘delhi’ can look like different things. In a test sheet, counting the cells equal to ‘Delhi’ with =COUNTIF(F1:F3,”Delhi”) returned 2 out of three. The sheet really contains Delhi, Delhi with a trailing space, and delhi. Excel ignores capital letters in this kind of comparison but not the extra space, so one of the three is missed. When you build lists, type each value the same way every time.
Practice
Make a sheet with five students, their names, an exam date and a mark out of 100. Type the dates properly, check that marks are right-aligned, use autofill for a roll number column and finish with a cell that adds the marks. If the total looks too small, check the alignment of every mark.
If one mark is left-aligned, retype it. If the problem came from pasted data, select the cells and use Data, Text to Columns, then Finish, which forces Excel to re-read the entries. Also look for a small green triangle in a cell’s corner: Excel is warning that a number is stored as text.
Adding units inside the cell, such as typing 40 kg or Rs 500. That turns a number into text. Type the number alone and put the unit in the header or the number format.
Check what you learned
Five quick questions. Pick an answer and you will see straight away whether it is right and why.
A number is left-aligned in its cell. What is the likely cause?
- It is a date
- It is stored as text
- It is too big
- The sheet is protected
Numbers align right by default.
Why did SUM ignore a value in the test sheet?
- It was negative
- It was a date
- It was stored as text
- It was zero
SUM adds only true numbers.
How does Excel store a date?
- As a number of days
- As a picture
- As a colour
- As a formula bar
That is why dates can be subtracted.
Which key edits the selected cell without retyping?
- F1
- Esc
- F2
- Tab
F2 puts the cell into edit mode.
Which layout is best for a data table?
- One header row and one record per row
- Blank rows between records
- Merged title cells inside
- Totals in the middle
A plain table works with every tool.
Summary
- Numbers align right; left-aligned numbers are probably text.
- Dates are stored as numbers of days.
- Keep data in a plain table: header row, one record per row.
- Spelling and extra spaces change results.
Questions
Why does my number show as 1.23E+10?
The column is too narrow, or the number is long. Widen the column or change the number format.
How do I stop Excel changing 1-2 into a date?
Format the cell as Text before typing, or type an apostrophe first, as in '1-2.
What is the green triangle in a cell?
A warning flag. Click the cell and the small icon to see the reason, such as a number stored as text.
