From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Create numeric formats: Display in thousands or millions

Create numeric formats: Display in thousands or millions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Create numeric formats: Display in thousands or millions

- [Instructor] Excel has a variety 2 of different numeric formats, and some of them are available 3 on the Home tab in the Number group, 4 and there are a few keystroke shortcuts, as well. 5 As you look at this worksheet, 6 your eye probably focuses on column C 7 because the way we're seeing numbers here 8 is certainly not standard and not easy to read, 9 and nearly anybody who's working with data of this type 10 would want to see commas. 11 Let's do this for the entire column. 12 One of the most common formats is found on that Home tab 13 in the Number group right here, Comma. 14 And when we first apply this, 15 we see the obvious commas, but also decimal places, 16 and certainly in this situation we don't need them. 17 So two buttons to the right, decrease the decimal, 18 looking like that. 19 You'll notice that in column C through F, 20 we have that same kind of display, 21 and notice that in each case there's a little bit…

Contents