Name: 數字格式化 - 貨幣、會計等 - Excel 2013 (Number Formatting - Currency, Accounting and More - Excel 2013)
Uploaded: 2021-01-14T06:56:12.000Z
Duration: 6 min 59 s
Description: 【看影片學英語】數萬部 YouTube 影片，搭配英漢字典即點即查，輕鬆掌握單字發音與用法，長久累積看電影不必再看字幕。

>> Hello. Today we're going to talk about number formatting.

It's the type of thing that can make a worksheet go

from functional to impressive, or in some instances

So right here I've kind of got this little looking

like maybe a quarterly finance thing, just some data.

Notice I've got some numbers here, so I'm going to look

So when I'm talking about number formatting I'm looking

So you notice we've got these three things right here.

They pretty much are what they look like.

which is not really what we would expect,

or I don't know maybe it is, maybe it isn't.

I probably should have chosen better numbers.

If I do a larger number where commas are actually going

to be relevant, well it's going to put commas in there,

probably like what you would have guessed.

If you've got big numbers, it's really nice

to have those commas separating the digits.

Let's move over to the next, probably most obvious one,

Notice that probably wasn't what you expected.

So what's happening here is there's a little math happening

the decimal place got moved twice and it got a percent sign.

So, it doesn't just put a percent sign, some math happens.

My best advice with percents is - so if you just enter data

like 51, it doesn't look like much and it's general.

If you take that same 51 and you just manually put the percent

because if you take an integer or just a normal number

and convert it to a percent often times you don't get what

I'll show you something kind of interesting.

If I were to take this percentage, 51, and I covert

that back to just a good old fashioned number, it's .51.

So you can see there's some math conversion happening there.

So, my best advice is if you're formatting something as percent,

fine just go ahead and do that, but if you're entering data,

right, like 40 percent I would just manually type

in the percent sign and you'll see that it'll do the math

for you and you'll probably get what you want.

Notice, no decimal places is the default here.

Pretty similar, both of them have a dollar sign.

Notice if you hover over it you get a tool tip, accounting,

so that tells you that that is accounting by default,

so not really the easiest thing to work with.

Me, let's say - so let's say I want to make these accounting.

You can make some mistakes, but just assuming that is something,

I like to pull down this menu and be sure

Right, and the accounting folks have the way they

So notice the difference here is they both have two decimal

The dollar signs are aligned to the right of the cells

with this weird split alignment, and that's the difference.

I personally don't care very much, but there are some people

that do care, and that is the difference.

There is one key difference though, it is negative numbers.

Plain number, that's pretty different right?

but in the accounting world negatives are typically denoted

字幕列表影片播放

數字格式化 - 貨幣、會計等 - Excel 2013 (Number Formatting - Currency, Accounting and More - Excel 2013)

weird

relevant

assume

obvious