Mengetik Angka Nol di Depan pada Microsoft Excel

Secara default, ketika kita mengetik angka nol pada paling depan di Excel, angka nol tersebut akan hilang. Ini akan menjadi masalah ketika kita ingin mengetik nomor HP atau ID yang berawalan angka nol. Pada artikel ini, saya akan menunjukkan beberapa cara untuk membuat angka nol tersebut muncul.

1. Mengetik Petik Satu Sebelum Angka Nol

Jika kamu ingin membuat agar angka nol di depan muncul, ketik petik satu sebelum mengetikkan angka nol tersebut seperti contoh di bawah ini.

excel leading zero

Hal ini akan membuat Excel menyimpan cell tersebut dalam format text.

Ketika kamu menekan “Enter”, excel akan menampilkan segitiga hijau di bagian kiri atas cell tersebut. Klik tanda segitiga kecil di sebelah kanan, lalu klik “Ignore Error”.

excel convert to number

Setelah langkah di atas dilakukan, segitiga hijau seharusnya langsung menghilang. Solusi ini dilakukan jika kamu hanya ingin melakukannya sekali saja. Jika kamu ingin membuat banyak cell bisa menjadi teks seperti ini tanpa harus mengetikkan tanda petik satu di depan, simak solusi selanjutnya.

2. Cell Formatting

Jika kamu ingin menambahkan banyak cell dengan angka nol di depan, sebaiknya gunakan solusi ini.

Pilih atau blok range cell yang ingin diformat menjadi text. Selanjutnya, masuk pada tab “Home”, lalu klik tanda panah kecil di samping dropdown bertuliskan General, lalu pilih “Text” seperti gambar di bawah ini.

excel change format to text

Angka nol yang diketik di awal akan selalu muncul pada semua cell yang telah diblok sebelumnya.

3. Membuat Fix Panjang Karakter dengan Angka Nol di Awal

Dua solusi sebelumnya cukup untuk sebagian besar permasalahan terkait angka nol di awal. Namun bagaimana jika kita perlu membuat fix panjang karakter di suatu cell, dan membuat angka nol di awal muncul otomatis?

Contoh, kita punya nomor ID yang harus berisi lima karakter seperti 00055 dan 03116. Berapapun nomor ID tersebut, jika kurang dari lima digit, ID akan selalu memiliki angka nol di awal agar jumlah karakter menjadi lima digit.

Untuk melakukan hal ini, pilih atau blok cell yang ingin diformat. Klik kanan, lalu klik “Format Cells”.

excel format cells

Pada tab “Number”, pilih “Custom” pada list Category, lalu ketik 00000 pada kolom Type.

excel format cells custom

Mengisi lima angka nol akan membuat excel memaksa agar cell yang dipilih sebelumnya selalu terdiri dari lima karakter, dengan menambahkan angka nol di awal jika kita menginputkan angka kurang dari lima karakter. Jika kita menginputkan tiga karakter, maka excel akan menambahkan dua angka nol tambahan di awal secara otomatis.

excel leading zeros

Kamu bisa mainkan lebih lanjut lagi sesuai kebutuhan untuk mendapatkan tipe formatting yang paling tepat.

29.371 comments

  1. livescore bet365

    These are in fact impressive ideas in about blogging. You have touched some fastidious factors here.
    Any way keep up wrinting.

  2. roulette casino online

    An outstanding share! I have just forwarded this onto a colleague who has been conducting a little research on this.
    And he actually ordered me breakfast because I stumbled upon it for him…
    lol. So allow me to reword this…. Thanks for the meal!!
    But yeah, thanks for spending time to discuss this matter here on your
    site.

  3. カジノ x ログイン

    certainly like your website but you have to take a look at the spelling on quite a few
    of your posts. Many of them are rife with spelling issues and
    I in finding it very bothersome to tell the reality on the other hand I will
    certainly come again again.

  4. sportsko kladjenje

    After looking at a handful of the articles on your
    site, I seriously like your technique of blogging. I bookmarked it
    to my bookmark webpage list and will be
    checking back soon. Please check out my website as well and
    let me know how you feel.

  5. 카지노 신규 쿠폰

    I enjoy what you guys are usually up too. This kind of clever work and reporting!
    Keep up the very good works guys I’ve included you guys to my blogroll.

  6. 1Xbet

    I am really impressed with your writing skills and also with the layout
    on your weblog. Is this a paid theme or did you customize it
    yourself? Anyway keep up the nice quality writing, it is rare to
    see a great blog like this one today.

  7. ライブカジノハウス

    Have you ever considered creating an e-book or guest authoring on other
    blogs? I have a blog based on the same ideas you discuss and would really like to have you
    share some stories/information. I know my
    readers would enjoy your work. If you’re even remotely
    interested, feel free to shoot me an email.

  8. カジノゲーム

    Whats up very nice web site!! Guy .. Excellent ..
    Wonderful .. I’ll bookmark your web site and take the feeds additionally?

    I’m glad to search out numerous helpful information right
    here in the submit, we’d like work out more techniques on this regard, thank you for sharing.
    . . . . .

  9. poker hand

    Hello friends, how is the whole thing, and what you would like to say about this article, in my view its in fact amazing in favor of me.

  10. plastic pots

    Howdy! I just want to give you a huge thumbs up for your excellent information you’ve got right here on this post.
    I am returning to your blog for more soon.

  11. 우리카지노

    There is definately a lot to learn about this subject.
    I love all of the points you’ve made.

  12. stay ready

    Have you ever considered about including a little bit more
    than just your articles? I mean, what you say is valuable and everything.
    Nevertheless imagine if you added some great photos
    or videos to give your posts more, “pop”!
    Your content is excellent but with pics and video clips, this blog
    could definitely be one of the most beneficial in its field.
    Excellent blog!

  13. https://konicasino.com/luckyniki/

    you are in point of fact a excellent webmaster. The website
    loading velocity is amazing. It kind of feels that you are doing any distinctive trick.
    In addition, The contents are masterpiece.
    you have performed a wonderful job in this topic!

  14. pokerstars

    Hey! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my
    blog to rank for some targeted keywords but I’m not seeing very good success.
    If you know of any please share. Appreciate it!

  15. backwoods papers

    That is really interesting, You’re a very professional blogger.

    I’ve joined your feed and look forward to seeking extra of your fantastic post.
    Also, I have shared your web site in my social networks

  16. カジノゲーム

    Pretty component to content. I simply stumbled upon your blog and in accession capital to assert that I acquire in fact loved account your blog posts.
    Anyway I’ll be subscribing on your augment or even I
    success you get admission to persistently rapidly.

  17. daftar pragmatic

    WOW just what I was searching for. Came here by searching for pragmatic play slot
    daftar

  18. 버스에서 춤을 추다

    Today, I went to the beachfront with my children. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed.

    There was a hermit crab inside and it pinched her ear.
    She never wants to go back! LoL I know this is entirely off topic but I had to tell someone!

  19. Peggy Namisnak

    Thanks a bunch for sharing this with all folks you actually realize what you are speaking about! Bookmarked. Please also consult with my site =). We can have a link exchange arrangement between us!

  20. 패디 파워

    Link exchange is nothing else however it is simply placing the other person’s website link
    on your page at suitable place and other person will also do same in favor of you.

  21. fun88 ทาง เข้า

    No matter if some one searches for his necessary thing, thus he/she
    wishes to be available that in detail, thus that thing is maintained over here.

  22. 메리트카지노

    It’s actually a nice and useful piece of information. I am satisfied that you shared this helpful
    information with us. Please keep us up to date like this.
    Thanks for sharing.

  23. dingdong online

    Howdy would you mind letting me know which webhost you’re utilizing?
    I’ve loaded your blog in 3 completely different browsers and I must say
    this blog loads a lot faster then most. Can you recommend a good web hosting provider at a fair
    price? Thank you, I appreciate it!

Tinggalkan Balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *