From the course: Excel 2010 Essential Training

Unlock the full course today

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

Formatting numbers and dates

Formatting numbers and dates - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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…

Contents