From the course: Excel Essential Training (Microsoft 365)

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Applying numeric formats

Applying numeric formats

From the course: Excel Essential Training (Microsoft 365)

Start my 1-month free trial

Applying numeric formats

- [Instructor] Numeric information can come to you in a variety of forms. On this worksheet called Numeric, we've got four different kinds of numbers in Columns B, C, D, and E. Now in Excel, every cell initially has a format called General. If the home tab is active and you click a cell, you're likely to see the word general there. Click over in Column A, that's the case. Column B, Column C. We keep seeing this word. If I click on one of the entries in Column D, it says Custom. That might throw us at first. But over in Column E, that's general too. But we need to change formats. Column E might be a starting point here. Now often in lists, we can simply click the column itself. That selects all the cells within the column. And a likely choice here might be dollar sign. I'll click it. Looks very much like the column to the left. If we make this column wider. I'll point to the boundary between Column E and F,…

Contents