Unit 2 · Topic 04 · Data Analysis and Representation (Google Sheets)

Data Formats (Number, Text, Date and Time, Currency)

Hook

The class had collected ₹1,450 for the book fair. Anaya counted the notes twice to be sure.

But the sheet on Pixel's screen insisted the total was ₹1,050.

Four hundred rupees had gone missing inside a spreadsheet.

The Story

"Somebody has taken it," said Anaya.

"Or the sheet is not adding one of the rows," said Kabir.

They looked. Four children had entered money: Anaya 250, Kabir 300, Meera 400, Rohan 500. All four numbers were right there on the screen.

Kabir noticed something small. Three of the amounts sat neatly against the right edge of their boxes. Meera's sat against the left edge, like a word.

"Because I typed Rs 400," said Meera. "To be clear."

Ms. Rao smiled. "And Sheets read it as clearly as you meant it. It saw letters, so it stored a word. Words do not add up."

She showed them the tell. In Google Sheets, numbers push to the right of the cell by themselves. Text sticks to the left. So a lonely left-hugging amount is usually a number in disguise.

Then she showed them the fix: Format ▸ Number, and a list — Number, Currency, Date, Time, Plain text. Meera deleted the letters, typed 400, and chose Currency. The cell showed ₹400 and jumped to the right.

The total became ₹1,450. Nobody had taken anything.

Anaya had made her own version of the mistake in the next column. She had typed 12 aug for the date, and it sat on the left too. Sorting the rows by date put 12 aug after 3 September, which is not how August works. She retyped 12/08/2026 and chose Date.

Pixel's fan groaned, exactly once, which for Pixel counts as a lesson learnt.

The missing ₹400 was never missing; it was text.

So What Just Happened?

A cell's format tells Sheets what kind of thing is inside it, and that decides what the cell can do. Set it with Format ▸ Number, then pick Number, Currency, Date, Time or Plain text.

Number adds, averages and sorts by size. Currency is a number wearing a ₹ sign — it still adds. Date and Time are stored as real points in time, so they sort properly. Plain text is for things that only look like numbers, such as a phone number or a room code.

The free clue is alignment. Numbers, currency, dates and times all push to the right of the cell by themselves. Text sticks to the left. So one left-hugging amount in a column of right-hugging ones is a warning sign.

Four formats, and the alignment tell that spots the odd one out.

Remember This

A cell's format says what kind of thing is inside: Number, Currency, Date, Time or Plain text.
Change it with Format ▸ Number, then pick the kind you need.
Numbers, currency and dates line up on the right; text lines up on the left.
Typing letters with a number, like Rs 400, turns the whole cell into text, and text never adds.
Real dates sort in true order; a typed 12 aug sorts like a word.

The alignment test and the one menu that fixes it.

Try It Yourself

In a new sheet, type 250 in A1 and Rs 250 in A2. Look at which side of the cell each one sits on.

In A3 type =A1+A2 and see what happens to the total.

Now fix A2: delete it, type 250, then choose Format ▸ Number ▸ Currency. Check A3 again.

Word Bank

Format: What kind of thing a cell holds, and how it is shown.
Currency: A number shown with a money sign, like ₹400, that still adds up.
Date and Time: Formats that store a real day or clock time, so they sort in true order.
Plain text: A format for things that only look like numbers, such as a room code.
Alignment: Which side of the cell an entry sits on: numbers right, text left.

Questions

Loading questions…