Lesson 4-3 from: Microsoft Excel 2013 Essential Skills (147 Video Lessons)

Quality

LOW

Captions

OFF
Transcript

OFF

Speed

1x

Format numbers using built-in number formats

Play The Video

ExcelCentral.com

Play

Back 10 Seconds

Slower

Faster

Full Screen View

Online Video Course: | Microsoft Excel 2013 Essential Skills | |
---|---|---|

Session: | Session 4: Making Your Worksheets Look Professional | |

Lesson: | Lesson 4-3 Format numbers using built-in number formats | |

Description: |
This lesson shows how to Format numbers using the Microsoft Excel built-in number formats. The Penny Rounding error problem is also discussed when a column of numbers in an Excel worksheet seem to have an addition error. You'll learn two solutions to this seeming addition error, best practice using the ROUND function, and a less desirable (and not recommended) solution achieved by changing precision to "set precision as displayed". You'll learn about the comma style, the Comma[0] style and the Currency[0] style and see them applied to a real-world worksheet. You'll then use the percentage (%) style to attractively format percentage values shown on an Excel worksheet. |