Home > Office > Mengganti Separator Desimal dan Ribuan pada Excel 2010

Mengganti Separator Desimal dan Ribuan pada Excel 2010


Tiba2 disamperin Mbos, nanyain gimana cara mengganti tanda separator untuk ribuan (menjadi titik) dan desimal (menjadi koma) pada Excel 2010.

Ga pake basa-basi, langsung menuju PC-nya si bos. oke, langkah2nya sebagai berikut:

dari menu File > Options, lalu klik tab Advanced. uncheck “use system separators”, masukkan tanda titik koma (,) pada rincian “decimal separator” dan tanda titik (.) pada rincian “thousands separator”. Klik OK.

Beres deh.. ternyata gampang banget kan?? 🙂

  1. March 26, 2019 at 3:07 am

    When I originally commented I seem to have clicked the
    -Notify me when new comments are added- checkbox and from now on every time a comment is added I
    get four emails with the exact same comment.
    There has to be a way you can remove me from that service?
    Appreciate it!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: