Currency column for revenue
Format column C as Accounting currency with two decimals so SUM still works while display shows dollar signs.
What is cell formatting in Google Sheets?
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, percent, date, and plain text formats keep reports readable and prevent Sheets from auto-converting IDs into dates. Good formatting is the difference between a sheet leadership trusts and one they argue with.
When to use it
Format when importing CSVs, building financial models, or sharing trackers with non-technical editors who should see friendly dates and dollar amounts instead of raw serial numbers.
When to skip it
Skip exotic formatting tricks when a simple number format and clear column headers already communicate the type. Over-formatting every cell slows collaboration and fights conditional formatting rules later.
How it works
-
1
Select cells and open Format > Number to pick Currency, Percent, Date, Time, or Plain text.
-
2
Use Format > Number > More formats > Custom number format for patterns like extra decimal places or leading zeros.
-
3
Set File > Settings > Locale when dates and commas flip between US and EU display conventions.
-
4
Apply Format > Text wrapping and alignment so long notes and headers do not hide neighbor columns.
-
5
Freeze rows and columns under View > Freeze so ID and header formatting stays visible while scrolling.
-
6
Use Paint format (Format painter) to copy number and text styles across similar columns quickly.
Examples in Google Sheets
Preserve leading zeros on SKUs
Set column A to Plain text before paste so 00421 stays 00421 instead of becoming 421.
Percent for win rate
Store 0.42 in the cell, format as Percent, so charts and averages treat the value as a true rate not 42.
Build this without starting from a blank cell
Use a Better Sheets tool for cell formatting, then watch a walkthrough when you want the full pattern.
Better Sheets resources
Common mistakes
- Formatting as currency but leaving text like "$1,200" in cells, which breaks SUM and QUERY math.
- Pasting dates that display wrong because locale assumes day-first while your team thinks month-first.
- Applying percent format to already multiplied values, showing 4200% instead of 42%.
- Hiding types with custom format tricks instead of fixing the underlying import from CSV.
- Mixing formatted display with exported CSV that strips symbols, confusing downstream tools.
Frequently asked questions
- Format vs value?
- Format changes display. The stored value may still be a number serial for dates or a decimal for percents.
- Why did my date become a number?
- Sheets stores dates as serial numbers. Pick a date format to show them human-readably again.
- Custom format for phone numbers?
- Use plain text or a custom pattern like (000) 000-0000 if digits are consistent length.
- Does formatting affect sorting?
- Sort uses underlying values. Text that looks like numbers may sort incorrectly until you convert types.
- Format entire column?
- Click the column letter and apply number format once so new rows inherit the same display rules.
- Conditional formatting vs number format?
- Number format sets default display. Conditional formatting adds color rules on top for thresholds.
- Can formatting break formulas?
- Rarely. Wrong type (text vs number) breaks math more than display format does.
- Copy formatting only?
- Use Paint format or Paste special > Formatting to spread styles without overwriting values.
Related Tutorials
Watch how cell formatting works
Embed a Number in a Website from a Google Sheet
Related blog posts
Guides that explain cell formatting in more depth.
Getting Started in Google Sheets Spreadsheet Management
Users can also customize the appearance of their spreadsheets with different fonts, colors, and themes.
Read post →Figure Out Frequency of Numbers
Discover how to figure out the frequency of numbers, product IDs, text, emails and much more! Essential tips and tricks revealed.
Read post →Spreadsheets Explained over 5 Levels of Difficulty
Master Google Sheets from simple text input to complex operations with our FREE tutorials, templates, and tools! Unleash the full power of spreadsheets now!
Read post →Related glossary terms
spreadsheet styling
Styling is the visual layer on top of raw data: fonts, fills, borders, banding, and theme colors that guide the eye to headers, inputs, and totals. Unlike number formatting, styling does not change values. It makes shared sheets scannable in meetings and reduces "where do I type?" questions from new editors.
Read guide →conditional formatting
Conditional formatting changes how cells look when they meet rules you define, such as values above a target or dates in the past. It helps scanners spot problems fast without writing values into extra helper columns. Rules can be simple comparisons or custom formulas that reference other sheets.
Read guide →reports from Google Sheets
A report turns raw data into a readable snapshot: summary metrics, charts, and tables formatted for an audience. Separate source data tabs from a Report tab that uses QUERY, pivot tables, or SUMIF so you refresh inputs without rebuilding layout every week.
Read guide →dashboards
A dashboard is a single view that answers "how are we doing?" without hunting across tabs. In Google Sheets, it is usually a summary tab with big numbers, charts, and conditional formatting fed by QUERY, pivot tables, or IMPORTRANGE from raw data you keep elsewhere.
Read guide →charts in Google Sheets
Charts in Google Sheets turn selected ranges into line, bar, pie, and combo visuals that update when source data changes. You insert from the Insert menu or chart editor, tie ranges to pivot tables or QUERY outputs, then publish or embed charts in Slides, Sites, and dashboards.
Read guide →Done reading about cell formatting?
Membership unlocks 636+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.