Skip to content
Tutorials Center
My learning

Topics

Lesson 4 of 29 ยท Getting Started

Formatting Cells

Format cells in Google Sheets: number, currency, percent and date formats, fonts, colors, borders, alignment, wrapping and merging, and why formats don't change values.

Formatting changes how a cell looks, never what it holds. A cell containing 0.256 can display as 0.256, 25.6%, 0.26 or $0.26, and every formula that reads it still sees 0.256. Understanding this split between the stored value and the displayed text prevents a whole family of mistakes, such as thinking a rounded display has rounded the data.

This lesson covers number, currency, percent and date formats, then text styling, borders, alignment, wrapping and merging. The menus are described in words. The TryIt blocks are stand-ins that implement the idea of a number format and a date format in JavaScript; they are not Google's engine, and the real format codes support much more.

Number formats

Select cells, then use Format > Number or the toolbar buttons. The common choices:

Pick the look, keep the value

Number 1,234.57 with separators and decimals.
Currency $1,234.57 with a symbol.
Percent 0.256 shows as 25.6%.
Date 2026-03-14 or Mar 14, 2026.
1 / 2

Other entries in the menu include Plain text (stops Sheets from interpreting your entry, useful for codes like 007), Automatic (the default guess), Time, Date time, Duration, Scientific, Accounting, Financial and Custom number format, which lets you write your own pattern.

A custom pattern uses 0 for a digit that always shows, # for a digit shown only when needed, a comma for thousands separators and a dot for the decimal mark. Text in quotes or symbols such as $ appears as written. A trailing % multiplies by 100 and adds the sign. Examples: #,##0.00, 0.0%, $#,##0, 0" kg".

JS A tiny number-format engine

Press Run (or Ctrl + Enter) to see the console output here.

No output.

The last lines are the lesson in miniature: a cell showing 20.00 still contains 19.999, and a formula that multiplies it uses 19.999. If you really want the value rounded, use ROUND (see SUM, AVERAGE, MIN, MAX and COUNT).

Dates and times

Dates are numbers underneath: a count of days since a starting date (December 30, 1899), with times as fractions of a day. The date format decides how that number is shown. Pick Format > Number > Date for the default style or Custom date and time to build your own from parts such as year, month and day. That is why a date that "turned into a number" is not broken: it only lost its date format. Apply a date format and it returns.

In the editor for custom date and time you assemble the pattern from chips, so you rarely type codes. The TEXT function, which uses codes like yyyy-mm-dd, appears in Dates and Times. The stand-in below shows both ideas: the serial number and the pattern letters.

JS One date, many displays

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Adding 30 to the serial gives a date 30 days later, which is exactly how =A1+30 works in a real sheet.

Text styling and colors

The toolbar gives you the font, size, bold, italic, underline, strikethrough and text color. Sheets uses fonts from a list in the dropdown, and you can add more with More fonts. Keep styling restrained: one font for the sheet, bold for headers, and color for meaning, not decoration. Fill color (the paint bucket) shades the cell background. Use a pale fill for input cells and a stronger one for headers.

Paint format (the paint roller icon) copies the formatting of one selection to another. Click it once for a single use, double-click to apply it to several places.

Borders, alignment and wrapping

  • Borders (the grid icon) add lines around or inside a selection. Choose the line color and style from the same menu. Use them to frame tables and totals; the default gridlines do not print unless you ask for them in the print settings.
  • Horizontal alignment is left, center or right. Numbers read best right-aligned so the digits line up; headers often match their column. Vertical alignment (top, middle, bottom) matters for tall rows.
  • Text wrapping has three modes: Overflow (text spills into empty neighbours), Wrap (text breaks onto several lines and the row grows) and Clip (extra text is hidden). Wrap is what you want for long labels in narrow columns.
  • Text rotation tilts or stacks headers over narrow columns.
  • Indent with the toolbar buttons to show hierarchy in labels.

Merging cells, and why to be careful

Merge cells joins a selection into one big cell, with options to merge all, vertically or horizontally. It is nice for a title that spans a table, but merged cells cause trouble: they break sorting and filtering, confuse formulas that expect a regular grid, and make copy and paste awkward. Prefer Center across thinking: put the title in the first cell, leave the others empty, and let it overflow. Merge only in presentation areas that no formula or sort will touch.

Never merge cells inside a data table. Keep one fact per cell, one record per row and one kind of data per column. Tables built this way sort, filter, pivot and chart without complaints.

Clearing and copying formats

Format > Clear formatting (Ctrl+\) removes the visual formatting and keeps the content. Paste special offers Paste format only to copy the look without data, and Paste values only to copy the data without the look. Between them you can restyle a sheet without touching what it holds.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. A cell holds 0.256 and is formatted as a percent. What does a formula that reads the cell receive?

    Formatting changes only the display. The stored value stays 0.256.
  2. 2. A cell holds 19.999 but displays 20.00 because of the decimal format. What does =A1*3 return?

    The formula uses the stored value 19.999, so the result is 59.997, whatever the cell displays.
  3. 3. Why do dates sometimes show up as plain numbers like 46095?

    Dates are counted days underneath. Apply a date format and the display returns.
  4. 4. Why should you avoid merged cells inside a data table?

    Merged cells break the regular grid that sorting, filtering and formulas expect.

Summary

  • Formatting changes the display, not the stored value; use ROUND when the value itself must change.
  • Number, currency, percent and date formats are chosen from Format > Number; custom patterns use 0, #, commas, dots and quoted text.
  • Dates are serial numbers, so a date that shows as a number just needs a date format.
  • Use fonts, fills, borders, alignment and wrapping with restraint, and copy looks with Paint format.
  • Avoid merging cells inside data tables.

Next: Your First Formulas