In this lecture let's take a look at some number formatting options that we haven't looked at yet.
Let's say you received this dataset from your HR department and you want to make it easier to read.
So we have a list of employee names.
Here we have their phone numbers.
Let's make this phone numbers look more like a phone number.
Let's highlight this and bring up number formatting.
The shortcut key was? Control+1.
Down here you see special, you have the ability to make these numbers look more like zip codes or more
like phone numbers.
So here you can see a preview.
Now this looks so much easier to read than the number there.
Click on OK
and all of these are formatted. But take a look at the formula bar. The number in the cell hasn't changed,
the way it looks has. So number formatting doesn't change the actual value, it just adds makeup to your cell.
Now let's also format yearly salary.
So for this we have different options.
We can directly click on the accounting number format here.
If you want it in a different currency, you can select the currency from here.
If you don't see it here, you can go to more accounting formats and select a symbol from this dropdown
arrow here.
Another option you have is to format this in the currency format.
So let's see what the difference between accounting and currency are.
That's the currency format.
So notice the dollar sign is stuck to the number whereas with accounting, the dollar sign is left aligned.
The other difference is also how zeros are represented.
So if I put a zero in this cell, this is how it looks in the currency format.
If we switch to accounting, that's how it looks with accounting.
So I'm just gonna press Control+z to go back.
Now you can also always influence the decimals by decreasing the decimal or increasing the decimal directly
from here.
If you don't want to show the currency symbol here, you can use a comma style type of number format and
then take away the decimals.
Another common style that I use is the number format directly from here.
I put a checkmark for use a thousand separator.
I changed the decimal places
if I don't want any, I put it to zero.
You can also select how you want negative numbers to be represented.
If you just wanted like the usual, you can select the first option which is generally the default when
you go to the number format.
So if we do these as well.
So if I highlight this, press Control+1, directly go to number.
All I have to do is use a thousand separator. If I don't want to have any decimals,
I'm going to put this to zero and then click on Ok.
Now for the difference.
Let's actually show the negative values in red. So there was an option for this, under number. So thousand
separator.
Let's not show any decimal and here I'm going to pick negative numbers to be shown as red
and in brackets.
OK.
And all of this is obviously dynamic.
So if our number increases here for previous year, our difference becomes negative. It's automatically
reflected as red. Now for the bonus,
this one is simple.
We're going to highlight this and we're going to change this to a percentage.
We can show a decimal, in this case anyhow
they're all zeros.
So I'm just going to collapse the decimal.
Okay, so these are the different number formatting options you can apply to your own data sets.