Intro to MS Excel Custom Formatting
An Excel number format consists of 4 sections of code, separated by semicolons, in this order: POSITIVE; NEGATIVE; ZERO; TEXT. In this introductory video we will quickly look at how we can use this to apply custom formatting to disguise values in cells.
Timestamps
00:00 Intro
00:13 Excel number format consists of 4 sections
01:07 Version of Excel used in this tutorial
02:01 Types of formatting applied in this example
03:09 Access custom format window via the top menu
03:33 Access custom format window via right clicking
03:48 Access custom format window via shortcut keys
04:43 Solution
06:32 Excel keeps and uses the original values
Resources:
Learning Microsoft Excel YouTube playlist: • Learning Microsoft Excel
Excel challenge: • Excel Challenge
WeCanEduTech Pinterest: / wecanedutech
WeCanEduTech Podcast: https://wecanedutech.podbean.com/
WeCanEduTech FB: / wecanedutech
#ExcelForMacAndWindows
#ExcelTips
#CustomFormatting
#WeCanEduTech