Subscriber only lesson.
Sign up to this course to view this lesson.
Number Formatting Part 4
Number Formatting explained using the CRaFT methodology.
When to use
Number Formatting can assist in building a financial model in Excel which is easy to understand and navigate through.
- The third section, [Green]_(\-_), specifies the formatting for zero values. This colors the zero values “Green”. Using a dash, generated by using \- here, denotes a zero as it distinguishes a zero value from something that is approximately zero, which can be useful for error checking, etc. .
- Finally, the fourth section, [Yellow], defines how text is to be formatted. If omitted, text is simply formatted as ‘General’, but here it will be colored yellow.
Lesson notes are only available for subscribers.