How to Format Numbers and Dates in Excel 2010


show more Formatting numbers and dates provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

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 ca...

Formatting numbers and dates
Video duration: 7m 6s 6h 21m Beginner

Viewers:

Formatting numbers and dates provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...