From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Formatting numbers and dates - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Formatting numbers and dates
Excel has two basic types of formatting. Or that's the way I look at it. You have formatting numbers and then you have formatting for colors, look, feel and fonts. Well formatting numbers is a little more straightforward and there's less to do so we're going to do that in this movie. Now when you look at this worksheet, you see we have the first quarter of the year and some calculations here in Column E and F and we have the cities we're going to, and then we have some other calculations down here at the bottom and we also have some dates. Well let's make these look like numbers because right now we can't tell are these dollars, are they euros, are they bananas? What are they? You see we do have some formatting here in Column F as percentages. So let's select the numbers across this first row and we also simultaneously want to select the numbers across the Total row so hold down the Ctrl key and your keyboard and just select across. So that's how you can select noncontiguous cells…
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.