Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills
2016 2013 2010 2007 Apple Mac

Format numbers using built-in number formats:

Lesson 4-3 from: Microsoft Excel 2013 Essential Skills (147 Video Lessons)
Format numbers using built-in number formats
Play Video
Play The Video
ExcelCentral Icon 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 Excel number format. Thumbnail from Excel 2013 Essential Skills 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.

Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email