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.

1.614 comments

  1. Genia

    Peculiar article, just what I needed.

  2. opinion instaboom

    I do not even understand how I finished up right here, however I thought this post used to be great.
    I do not recognise who you might be but definitely you are going to a well-known blogger in the event you are not already.

    Cheers!

  3. Dessie

    Interesting blog! Is your theme custom made
    or did you download it from somewhere? A design like yours
    with a few simple adjustements would really make my blog jump out.

    Please let me know where you got your design.
    Kudos

  4. Florence

    all the time i used to read smaller articles that
    also clear their motive, and that is also happening with this paragraph which I am reading here.

  5. Michal

    Hi there! I know this is somewhat off topic but I was wondering which blog platform are you using for this website?
    I’m getting fed up of WordPress because I’ve had problems with hackers
    and I’m looking at alternatives for another
    platform. I would be great if you could point me in the direction of a good platform.

  6. mike tyson vs roy jones livestream

    Ahaa, its fastidious discussion concerning this paragraph here at this weblog, I have
    read all that, so now me also commenting at this place.

  7. webpage

    This site was… how do I say it? Relevant!! Finally I have found something which helped me.
    Thanks a lot!
    webpage

  8. Virgil

    Nice answers in return of this difficulty with genuine arguments and describing the whole thing on the topic of that.

  9. Eliza

    I was suggested this website by my cousin. I am
    not sure whether this post is written by him as no one else know such detailed about my problem.
    You’re wonderful! Thanks!

  10. p15477

    Please let me know if you’re looking for a article writer for your weblog.
    You have some really great articles 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 articles for your blog in exchange for a link
    back to mine. Please shoot me an email if interested.
    Kudos!

  11. Situs BandarQ

    When set on sleep mode, the fitness tracker actually records your motion during
    sleep, how many instances you rise up and precise sleeping
    hours.

  12. Battery Machine

    Hey there, You have done a great job. I will definitely
    digg it and personally recommend to my friends. I am confident
    they will be benefited from this website.

  13. Sergio

    I blog often and I seriously thank you for your content.

    This great article has truly peaked my interest. I’m going to take a
    note of your blog and keep checking for new details about once a week.

    I subscribed to your RSS feed as well.

  14. judi idn poker terbesar

    Ahaa, its fastidious conversation on the topic of this post at this
    place at this weblog, I have read all that, so now me also commenting here.

  15. Link Alternatif Joker123

    Thank you for any other great post. The place else may just anybody get that kind of
    information in such an ideal way of writing? I have a presentation subsequent
    week, and I am on the look for such information.

  16. Vacuum gauge

    Incredible points. Outstanding arguments. Keep up
    the good effort.

  17. dewi365

    What’s up, I log on to your blog like every week. Your story-telling style is witty, keep it up!

  18. 美国寄快递到中国

    It’s really a nice and helpful piece of info. I am satisfied that you just shared this useful info with us.
    Please keep us informed like this. Thanks
    for sharing.

  19. best treadmill for walking

    Admiring the commitment you put into your site and detailed information you offer.
    It’s awesome to come across a blog every once in a while that isn’t the same
    out of date rehashed information. Wonderful read! I’ve
    bookmarked your site and I’m adding your RSS feeds to my Google account.

  20. https://hardlenses.com/index.php?title=User:DemetriusHackney

    I have been browsing online more than 3 hours today, yet I never found any interesting article like yours.

    It is pretty worth enough for me. In my opinion, if all
    webmasters and bloggers made good content as you did, the net will
    be a lot more useful than ever before.

  21. badoo premium ipa cracked

    That is a really good tip particularly to those fresh to the blogosphere.
    Brief but very precise information… Thanks for sharing this one.
    A must read post!

  22. badoo premium iptal etme

    Good post! We will be linking to this particularly great post
    on our website. Keep up the good writing.

  23. badoo premium latest apk download

    Thanks for your marvelous posting! I seriously enjoyed reading it, you might be a great author.

    I will ensure that I bookmark your blog and will eventually
    come back at some point. I want to encourage you continue your great
    posts, have a nice morning!

  24. free credits for badoo app

    Please let me know if you’re looking for a
    article writer for your weblog. You have some really great articles and
    I feel I would be a good asset. If you ever want
    to take some of the load off, I’d really
    like to write some material for your blog in exchange for a
    link back to mine. Please blast me an e-mail if interested.
    Thank you!

  25. All Recipes

    Hello There. I found your blog using msn. This is an extremely well written article.

    I’ll be sure to bookmark it and come back to read more of your
    useful info. Thanks for the post. I will certainly
    comeback.

  26. badoo free credits pc

    Thank you for some other informative site.
    Where else may I am getting that type of info written in such an ideal manner?
    I have a venture that I’m simply now running on, and I’ve been at the glance out for such information.

  27. badoo premium apk 2019 ios

    It’s really a great and helpful piece of info.
    I’m satisfied that you just shared this useful information with us.
    Please keep us informed like this. Thank you for sharing.

  28. badoo free wifi

    Howdy are using WordPress for your blog platform? I’m new to the blog world but I’m trying to
    get started and create my own. Do you require any
    html coding expertise to make your own blog?

    Any help would be greatly appreciated!

  29. robux generator

    hi!,I really like your writing so so much! percentage we keep up
    a correspondence more approximately your article on AOL?

    I require a specialist on this space to solve my problem.
    May be that is you! Taking a look ahead to look you.

Tinggalkan Balasan

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