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.455 comments

  1. treadmill reviews canada

    I know this if off topic but I’m looking into starting my own weblog
    and was curious what all is required to get set up?
    I’m assuming having a blog like yours would cost a pretty penny?
    I’m not very internet savvy so I’m not 100% positive.
    Any recommendations or advice would be greatly appreciated.

    Appreciate it

  2. web design

    Hi! Do you know if they make any plugins to protect against
    hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any recommendations?

  3. pkv Games

    Thanks , I’ve recently been searching for information approximately this subject for ages and yours is the best I’ve found out so far.
    But, what concerning the conclusion? Are you positive concerning the
    supply?

  4. ver URL de instagram privada

    Hey there this is kinda of off topic but I was wondering if blogs use
    WYSIWYG editors or if you have to manually code with HTML.
    I’m starting a blog soon but have no coding know-how so I wanted to get
    advice from someone with experience. Any help would be greatly appreciated!

  5. Janet

    I’m truly enjoying the design and layout of your site. It’s a very easy on the eyes which makes it much more enjoyable for
    me to come here and visit more often. Did you hire out a developer to create your theme?

    Excellent work!

  6. ver instagram privado en la computadora portátil

    Fantastic blog! Do you have any helpful hints for aspiring writers?
    I’m hoping to start my own blog soon but I’m a little lost on everything.
    Would you suggest starting with a free platform like WordPress or go for
    a paid option? There are so many choices out there that I’m completely overwhelmed ..
    Any ideas? Thanks!

  7. Fiona

    Heya just wanted to give you a quick heads up and let you know
    a few of the pictures aren’t loading properly. I’m not sure
    why but I think its a linking issue. I’ve tried it in two different internet browsers and
    both show the same results.

  8. ver instagram privado sin verificación humana 2018

    I don’t know if it’s just me or if perhaps everyone else encountering issues with your website.
    It seems like some of the text within your content are
    running off the screen. Can someone else please provide feedback and let me know if this is happening to
    them too? This could be a problem with my browser because I’ve had
    this happen previously. Kudos

  9. Muriel

    I’ve been browsing online more than 3 hours today,
    yet I never found any interesting article like yours.
    It’s pretty worth enough for me. Personally, if all website
    owners and bloggers made good content as you did, the net will be a lot more
    useful than ever before.

  10. forma legítima de ver instagram privado

    I like the helpful info you provide in your articles.
    I will bookmark your blog and check again here frequently.
    I am quite sure I’ll learn a lot of new stuff right here!

    Best of luck for the next!

  11. Deposit Pulsa Slot Joker Tanpa Potongan

    That is very attention-grabbing, You are a very skilled
    blogger. I’ve joined your feed and look ahead to looking for
    extra of your excellent post. Additionally, I’ve shared
    your website in my social networks

  12. click here

    Appreciate the recommendation. Will try it out.

  13. ver instagram privado sin encuesta

    A motivating discussion is definitely worth comment. I think that you should publish more on this subject matter, it may not be a taboo subject but typically people don’t talk about these
    issues. To the next! Kind regards!!

  14. vacuum glovebox

    Hey there! 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. Kudos!

  15. ver instagram privado en línea gratis

    Hi would you mind stating which blog platform you’re using?
    I’m going to start my own blog soon but I’m having a hard time deciding between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your layout seems different then most blogs and I’m
    looking for something completely unique.
    P.S My apologies for being off-topic but I had to ask!

  16. Lurlene

    Hello there, You’ve done an incredible job. I’ll definitely digg it and personally recommend to my friends.
    I am sure they’ll be benefited from this web site.

  17. XSQN

    Hi there! I could have sworn I’ve been to this website before
    but after reading through some of the post I realized it’s
    new to me. Anyways, I’m definitely delighted I found it
    and I’ll be bookmarking and checking back often!

  18. Monserrate

    I’m not sure exactly why but this site is loading very
    slow for me. Is anyone else having this problem or is
    it a issue on my end? I’ll check back later
    on and see if the problem still exists.

  19. ver tweak de jailbreak de instagram privado

    Sweet blog! I found it while browsing on Yahoo News.
    Do you have any tips on how to get listed in Yahoo News?
    I’ve been trying for a while but I never seem to get there!
    Cheers

  20. Victorina

    Hello, i think that i noticed you visited my weblog thus i got here to go back the favor?.I am trying to in finding things to improve my site!I suppose its adequate to use some
    of your ideas!!

  21. Will

    Oh my goodness! Amazing article dude! Thank you, However I am having issues with your RSS.

    I don’t understand the reason why I am unable to join it.
    Is there anybody having identical RSS issues? Anybody who knows the answer will you
    kindly respond? Thanx!!

  22. SXTB

    I like this site very much, Its a real nice spot to read and incur info.

  23. Deangelo

    I loved as much as you’ll receive carried out right here.
    The sketch is tasteful, your authored material
    stylish. nonetheless, you command get got an shakiness over that you wish be delivering the
    following. unwell unquestionably come more formerly
    again since exactly the same nearly a lot often inside case you shield this hike.

  24. 电化学工作站

    Wonderful beat ! I wish to apprentice while you amend your web site, how could i subscribe
    for a weblog website? The account aided me a acceptable deal.
    I were tiny bit familiar of this your broadcast provided brilliant clear idea

  25. divineartcafe.org

    It is perfect time to make some plans for the long run and it’s time to
    be happy. I’ve learn this post and if I may I desire to suggest you few attention-grabbing issues or suggestions.

    Maybe you could write subsequent articles relating to this article.
    I want to read even more issues about it!

  26. bandar Sakong

    What’s Taking place i am new to this, I stumbled upon this I
    have discovered It absolutely helpful and it has helped me out loads.
    I am hoping to contribute & assist different users like its aided me.
    Good job.

  27. Free live chat

    I really like what you guys tend to be up too.
    Such clever work and exposure! Keep up the fantastic works guys I’ve added you guys to
    blogroll.

  28. Jeremy

    Great post.

Tinggalkan Balasan

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