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.

28.081 comments

  1. 유로파리그중계

    When I take a look at your blog in Safari, it looks fine however, if opening in I.E., it’s got some overlapping issues.

  2. 구글상위노출

    When I originally commented I appear to have clicked on the -Notify me when new comments are added- checkbox and from now on each time a comment is added I get 4 emails with the exact same comment. Is there a means you can remove me from that service? Cheers!

  3. 해외스포츠중계

    When I initially commented I appear to have clicked on the -Notify me when new comments are added- checkbox and from now on each time a comment is added I get four emails with the same comment. Perhaps there is a way you are able to remove me from that service? Appreciate it!

  4. 챔피언스리그중계

    When I look at your blog site in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping.

  5. 메이저리그중계

    Whats up very cool site!! Guy .. Excellent .. Wonderful .. I will bookmark your blog and take the feeds additionally…I’m satisfied to search out so many helpful information right here within the publish, we want develop extra strategies on this regard, thanks for sharing.

  6. 김해출장마사지

    When I look at your blog site in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping.

  7. 스포츠픽

    Where Is The Best Place To Buy Generic Viagra Online [url=https://www.viaonlinebuy.us/]viagra pill[/url] – Generic Viagra Price Comparison

  8. 해외스포츠중계

    When I initially commented I appear to have clicked on the -Notify me when new comments are added- checkbox and from now on each time a comment is added I get four emails with the same comment. Perhaps there is a way you are able to remove me from that service? Appreciate it!

  9. dressler ophthalmology

    Nice weblog right here! Additionally your web site lots up very fast!
    What web host are you using? Can I am getting your affiliate
    link for your host? I want my site loaded up as quickly as yours lol

  10. 해외스포츠중계

    When I initially commented I appear to have clicked on the -Notify me when new comments are added- checkbox and now every time a comment is added I receive four emails with the same comment. There has to be an easy method you can remove me from that service? Thanks!

  11. 유로파리그중계

    when i read this post i thought i could also make comment due to this sensible piece of writing.

  12. 유로파리그중계

    When I originally left a comment I appear to have clicked on the -Notify me when new comments are added- checkbox and now each time a comment is added I get four emails with the exact same comment. Perhaps there is an easy method you can remove me from that service? Many thanks!

  13. 챔피언스리그중계

    When I initially left a comment I seem to have clicked on the -Notify me when new comments are added- checkbox and from now on each time a comment is added I get 4 emails with the same comment. Perhaps there is a means you can remove me from that service? Many thanks!

  14. 챔피언스리그중계

    When I originally commented I appear to have clicked on the -Notify me when new comments are added- checkbox and now every time a comment is added I get four emails with the exact same comment. Is there a means you are able to remove me from that service? Thank you!

  15. 스포츠분석

    While they don t keep the same type of statistics for sex as they do for major league baseball otherwise you may not want to see your batting average or on-base percentage , one has to wonder how using such sex PEDs may have altered the perceptions, dynamics, psychology, emotional aspects, and health of sex.

  16. 챔피언스리그중계

    When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get four emails with the same comment. Is there any way you can remove people from that service? Cheers!

  17. 스포츠픽

    When someone writes an paragraph he/she keeps the idea of a user in his/her mind that how a user can know it.

  18. mgm 바카라

    Great information. Lucky me I discovered your site by chance (stumbleupon).

    I’ve bookmarked it for later!

  19. クイーンカジノ

    I need to to thank you for this fantastic read!!
    I absolutely enjoyed every bit of it. I have you
    saved as a favorite to check out new stuff you post…

  20. mlb야구중계

    What’s up colleagues, its wonderful article about cultureand fully defined, keep it up all the time.

  21. mlb야구중계

    What’s up Dear, are you genuinely visiting this site on a regular basis, if so then you will without doubt take pleasant know-how.

  22. 스포츠토토분석

    What’s up to every body, it’s my first visit of this website; this website carries remarkable and really fine stuff

  23. 일본야구중계

    What i don’t understood is actually how you’re now not really much more well-favored than you may be now. You’re very intelligent. You realize therefore considerably when it comes to this subject, produced me for my part imagine it from so many various angles. Its like men and women are not involved unless it is one thing to do with Girl gaga! Your individual stuffs great. Always handle it up!

Tinggalkan Balasan

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