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.

3.109 comments

  1. slot pragmatic online

    Excellent goods from you, man. I have understand
    your stuff previous to and you’re just extremely magnificent.
    I really like what you’ve acquired here, certainly like what you’re
    saying and the way in which you say it. You make it entertaining and you still
    take care of to keep it wise. I can’t wait to read much more from you.

    This is really a wonderful web site.

  2. http://portal-db.live/go-hallco-org

    Hey there I am so thrilled I found your blog page, I really found
    you by accident, while I was browsing on Bing for something else, Anyhow I am here
    now and would just like to say kudos for a incredible post and
    a all round thrilling blog (I also love the theme/design),
    I don’t have time to read through it all at the moment but I have book-marked it and
    also included your RSS feeds, so when I have time
    I will be back to read a lot more, Please do keep up the superb work.

  3. Undertale Gratuit

    I’m really enjoying the theme/design of your weblog.
    Do you ever run into any browser compatibility issues? A
    small number of my blog readers have complained about my website not working correctly in Explorer but looks great in Opera.
    Do you have any advice to help fix this problem?

  4. Movavi Crack

    Hi to every body, it’s my first visit of this webpage; this blog carries amazing and really good data
    in support of visitors.

  5. Poker online terpercaya

    Thanks for another informative website. Where else could I am getting
    that type of information written in such an ideal manner?
    I have a venture that I am simply now operating on, and I’ve been on the glance
    out for such information.

  6. Porno izle

    Hi, i read your blog from time to time and i own a similar one and i
    was just wondering if you get a lot of spam
    responses? If so how do you stop it, any plugin or anything you can suggest?
    I get so much lately it’s driving me insane so any support is
    very much appreciated.

  7. qq online terpercaya

    Please let me know if you’re looking for a article writer for your weblog.
    You have some really great posts and I think I would be a good asset.

    If you ever want to take some of the load off, I’d really like to write some content for your blog
    in exchange for a link back to mine. Please shoot me an e-mail if interested.
    Cheers!

  8. chicagosexualhealth.com

    Quality posts is the important to be a focus for the people to pay a visit the site, that’s what this web page is providing.

  9. www.endometriosispr.net

    Wow, marvelous blog layout! How long have you
    been blogging for? you make blogging look easy. The overall look of your web
    site is fantastic, let alone the content!

  10. Vaughn

    Pretty great post. I simply stumbled upon your weblog
    and wished to mention that I’ve truly enjoyed browsing your blog posts.
    In any case I will be subscribing on your rss feed and I’m hoping you write again very soon!

  11. Lloyd

    Hey There. I found your blog using msn. This is a very well
    written article. I will be sure to bookmark it and come back to read more of your useful
    info. Thanks for the post. I’ll definitely comeback.

  12. Poker online terpercaya

    If you wish for to obtain a great deal from this post then you have to apply such
    techniques to your won web site.

  13. Jessika

    When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment.

    Is there any way you can remove me from that service?

    Cheers!

  14. Joker388 online

    Just desire to say your article is as astounding. The clearness in your
    put up is just cool and i can think you’re a professional in this subject.

    Fine along with your permission let me to clutch your RSS feed to keep up to
    date with approaching post. Thank you a million and please carry on the enjoyable work.

  15. Angel Berrocal

    Does your website have a contact page? I’m having problems locating it but, I’d like to send you an email. I’ve got some suggestions for your blog you might be interested in hearing. Either way, great website and I look forward to seeing it grow over time.

  16. iphone

    Iphone 12 мини и макс начнут продавать позже, аж с 13 ноября.
    Уже есть проверенная инфа.

  17. daftar

    Excellent goods from you, man. I have tak into account your
    stuff previous to and you’re just extremely great. I really like what
    you have received here,certainly lke what you’re stating and the best way through which you say it.
    You make it entertaining and you still take caqre of to stay
    it smart. I can’t wait to learn far more from you. This is
    really a wonderful web site.
    daftar bahdar terpercaya

  18. qq online terpercaya

    I am sure this piece of writing has touched all the internet viewers, its really really nice article on building
    up new webpage.

  19. kn95 maske kaufen

    Every weekend i used to pay a quick visit this web page, for the reason that i want enjoyment, since this this website conations really good
    funny stuff too.

  20. Celia Mceachern

    Hello there! Would you mind if I share your blog with my myspace group? There’s a lot of people that I think would really appreciate your content. Please let me know. Cheers

  21. Becky

    Hi there, this weekend is pleasant in favor of me, for the reason that this
    point in time i am reading this enormous educational article here at my house.

  22. sexy naked females

    Slut naked cam charonnfoxxyx: I am a funny girl with an open mind.
    ready to satisfy your wishes. I am here for you if you want to talk or
    want to play fun and have a good time together hot video chat

  23. volkswagen passat battery cost

    I really like reading a post that can make men and women think.

    Also, thank you for allowing me to comment!

  24. einweg masken kaufen

    I have been surfing online more than 3 hours today, yet
    I never found any interesting article like yours.
    It’s pretty worth enough for me. In my view, if all site owners and bloggers made good content as you did, the web will be much more useful than ever before.

  25. Marietta

    Hello to every body, it’s my first visit of this weblog; this weblog
    contains remarkable and genuinely fine material designed for readers.

Tinggalkan Balasan

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