From the course: Excel 2016: Advanced Formatting Techniques
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Work with numeric formatting options
From the course: Excel 2016: Advanced Formatting Techniques
Work with numeric formatting options
- Excel has a number of different numeric formats and on this worksheet, called, "AccountingCurrencyComma," I've abbreviated those terms, we're going to look at some of the different formats that are used as you work with numbers. Column E says "Salary," I could use dollar signs there, I probably don't really need to do that, since the word salary emphasizes that idea. But certainly one of the most common tools used for formatting is this dollar sign button that appears in the Number group on the home tab. Notice as you slide over this it says, "Accounting Number Format." Click it and we get this look. Some people are a little surprised because it looks like there's a space on the right hand side. And something else you might notice if the column were wider, no reason to really make it wider now, but if you do, the dollar sign hangs on to the left hand side, and nothing wrong with this. And by the way, this is also affected by whether you might have right alignment here, or center…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.