Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Formatting Data | Formatting of Cells and Ranges
Google Spreadsheets Tutorial

bookFormatting Data

Google Sheets allows you to format numbers in different ways to display them according to your needs. Below is a list of common number formats that help present data accurately while maintaining readability.

question mark

Select all correct statements.

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 2. ChapterΒ 2

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

Suggested prompts:

Can you explain the difference between formatting as plain text and as a number?

How do I choose the best format for my data in Google Sheets?

What happens if I format a cell as scientific notation by mistake?

Awesome!

Completion rate improved to 1.45

bookFormatting Data

Swipe to show menu

Google Sheets allows you to format numbers in different ways to display them according to your needs. Below is a list of common number formats that help present data accurately while maintaining readability.

question mark

Select all correct statements.

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 2. ChapterΒ 2
some-alt