To change the number of decimal points that you see showing in the cell, find the icons highlighted in the screenshot below, just above the spreadsheet. As you can see in this screenshot, the cell appears to be $1,100, while the underlying data has a decimal amount as shown in the formula bar. You can always click in a cell and check the formula bar, as you can see in the screenshot below, to check the real value of a cell. This illustrates an important concept about spreadsheets: the data that's behind the scenes can differ from how you're viewing it. In either case, you can tweak the number of decimal points that are showing in the spreadsheet. (0.4 people can't be finished with a project, but someone could be 40% finished)
Decimal points are showing in your data, but you're working with data that shouldn't be fractional. (For example, who typically cares about 24 cents at the end of $1,000,000 in a cell?) Your data has decimal amounts in it, but you don't want to show them in the cell for simplicity's sake. There are really two key scenarios that this comes in handy: You might also want to tweak the number of decimal points that show in your spreadsheet. Just remember that this doesn't automatically convert the amounts, it simply changes the currency symbol.įor our readers in other regions, don't miss out on the fact that you can change the currency symbol that's presented. From the 123 (number formatting) menu option, choose More Formats > More Currencies to select a new currency symbol to add to your data.Ĭhoose another currency symbol to localize your Google spreadsheets. With your data highlighted, click on the 123 icon, and then choose More Formats > More Currencies as you can see in the screenshot below. The currency symbols quickly give the clues to the user that these amounts are more than simple numbers.įor our readers in other regions, don't miss out on the fact that you can change the currency symbol that's presented. This is a perfect example of how formatting makes a spreadsheet more meaningful. With your financial amounts selected, find the currency symbol on the toolbar and click on it to style your data accordingly. Then, click on the dollar sign just above the data to apply currency formatting to the entire selection. In the example screenshot below, both the "Amt" and "Hourly" columns would benefit from currency formatting. To format data, always start off by clicking and highlighting the data that you want to apply the format to. That's why formatting numbers as currency is so useful. While "$504.53" clearly refers to a currency amount, "504" in a cell isn't as intuitive. Spreadsheets often hold financial information, so it makes sense that formatting should show that. Let's look at some tweaks you can apply to data to make it more understandable. When I glance at a number, I should at least have a basic idea of what type of data we might be talking about. Even though they're both numerical values, you would a dollar amount, and the number of items your purchased to be formatted differently. One of the most important parts of formatting Google cells is making sure that your data has the correct format for the type of data it holds. 
Keep reading to see an illustrated guide for creating great-looking Sheets. You'll get a chance to see how I think about adding styles and formatting to emphasize cells. In the screencast below, I'll give you an "over the shoulder" look at how I handle formatting a raw spreadsheet in Google Sheets.
You'll learn how to edit Google Sheets with essential formatting for easy reading. Let's jump in! How to Edit Google Sheets (Watch & Learn) In this tutorial, I'm going to jump around and show you all of the essential skills you need to format Google spreadsheets. Text wrapping can help oversized blocks of text fit in a single cell without wrapping and extending to additional cells.Alignment, which allows you to put the content to the left, center, or right side of a cell, creates natural whitespace that makes a spreadsheet easier to read.Bold cells draw a viewer's attention and let them know that the data in a selected cell is more important than the surrounding Google cells.Here are just a few of the formatting tools that we'll cover in this tutorial: Use formatting in Google Sheets to make it easy to read and collaborate on spreadsheets, right inside of a web browser. With a bit of formatting, it's much easier to read a spreadsheet and find meaning inside of it. When a spreadsheet is properly formatted, you can glance over the data and understand it much more quickly than flat data alone. Formatting a spreadsheet is really about adding style so that your data is easy to read and interpret.
0 kommentar(er)
