How to Get a Thousands Separator in Excel 2010

http://www.worksmarter.tv Watch this video to learn how to display a thousands separator in your values in Excel 2010
79

---

Closed Caption:

welcome to work smarter TT I magnin
in this video I will show you how to
told thousands
separator in XO we have the
population data for or the
you countries between 2001 2012 here
and as you can see these are quite large
numbers and
it would really help people would have
like thousand separator every like 1000
million would be a coma in
US setting because it makes it easier to
you
just estimate how big this is because I
can see if it's like for
$48 million or for 180 million like this
reduces follows
respect to sell and we go to the
thousand common style
displaced affiliate is placed you show
with thousand separator
and what happens now
is dead it says yet is nice but I can't
fitness continue
show we have to just so with
well and you can t know it we can easily
see it also added 20 s
did not today accounting number
formatting
which different options as well but
for now we'll just 2002 British ed 206
when this way
became too small but you can see it I
cannot
great very easy for on million now let's
do this for
all that cells and as you can see
we have to change just all the columns
now we can do this all at once but just
double clicking here
modesty how wide every individual
economy to be
and you can see our data is much easier
to interpret now
although let's get rid of it euros
always used for
new the room on 1st alright now you can
see is yours are gone
and we can also readjust make the
columns a bit smaller you know
we forget you came
not duties for column because it is
alleged
your now we just as well as well we r
now if you have the decimal separator
something different for instance in in
Europe
we used the other way around you have
the point for thousand separator
comma for it the decimal point
dan it works the same need a result
XD
I want to keep the color scheme and keep
streaming guys
at sorry about that I am I hope you find
this review helpful
if you have any questions you can leave
them in the comments
you can also subscribe to my YouTube
channel by clicking the subscribe button
this video and if you want to receive
email updates when a person you video
and get tips and tricks on how to use
Excel inspired awaiting your inbox
head over to my website works by the TV
my kicking
button in the bottom right corner and
signed up for my meeting
East there thank you for watching hope
to see you next time
bye bye