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.

17.783 comments

  1. Chachurbate.com

    The Texas Court of Criminal Appeals (“CCA”) made this abundantly clear in 2000
    in the case of Rudolfo Lopez. 1/ Lopez was convicted of sexually assaulting a 12-year-old boy (forcing the boy to perform oral sex on him over
    a period of several months) and sentenced to twelve years in prison. “Credibility of the witnesses is no more important in sex offenses than in any other case.
    There are usually no witnesses in sex offense
    cases; therefore, the credibility of the alleged victim and defendant are more critical issues.
    In each of these examples, there is no physical
    evidence and there are no additional witnesses
    to the crime. The primary reason is that the evidentiary rules of evidence are stacked against the defendant in favor
    of protecting the alleged victim from further emotional “trauma” associated with sexual assault.
    The increased emotional level associated with sexual offenses is all the more reason to refuse to allow
    the jury to be additionally confused by collateral
    acts of misconduct by a witness.

  2. buy golden teacher mushroom

    Hi there, for all time i used to check web site posts here early in the morning,
    for the reason that i enjoy to learn more and more.

  3. 토토사이트

    Now make confident that the betting web web page presents reside
    streaming as effectively as reside betting.

  4. 카지노사이트

    Hi! I know this is kind of off topic but I was wondering if you knew
    where I could get a captcha plugin for my comment form?
    I’m using the same blog platform as yours and I’m having difficulty
    finding one? Thanks a lot!

  5. free online sports betting

    By March, NY lawmakers will know much more about the federal stimulus and coronavirus relief package coming to the state.

  6. Clarita Button

    So much hose love here! With out the love and emotional support of John’s mother, John often felt at lack of love, which resulted in the affairs
    he had with countless women while Jackie was away. In this hot fat sex scene we have Jackie teasing her partner with her awesome set of plump tits and cute belly.
    Having fun while having sex. We appreciate that naughty fun! 10.) More headaches then are natural.
    Please feel free to explore our exciting solo, erotic,
    sensitive and breath taking photo scenes and enjoy these nude models curvy shapes, natural breasts, velvet pussies and welcome into gorgeous girls’
    erotic dreams. We record thousands of private and public shows of almost all models of webcams industry, you will
    definitely find something for yourself – girls, lesbians, trans, homosexuals, boys –
    masturbates, fucks, cum in every video record!
    BECOME A BONGA MODELS CAM MODEL TODAY! Sex cam online conversation with hundreds of appealing Internet performers from throughout
    the Globe. Get ready for 18 girls sex videos like you’ve never seen before.
    We Are The Washitaw (The Washitaw Doctrine) by R A Umar S.
    Bey is much easier to get hold of and a copy is on it’s way
    to me now.

  7. Handball

    You spot a bet and if you shed, the bet is refunded as a free bet and you can try your luck again.

  8. เว็บพนันวอเลท2021

    Thank you a lot for sharing this with all people you actually know what you’re
    speaking about! Bookmarked. Kindly additionally seek advice from my website =).

    We could have a link alternate contract among us

  9. Susanna Pemulwuy

    Greetings from California! I’m bored to tears at work so I decided to browse your blog on my iphone during lunch break.
    I enjoy the knowledge you provide here and can’t wait to take a look when I
    get home. I’m shocked at how fast your blog loaded on my mobile ..
    I’m not even using WIFI, just 3G .. Anyways, fantastic site!

    Feel free to visit my website :: FastySlim

  10. Eternal Nutrition Male Enhancement Reviews

    I’m impressed, I have to admit. Rarely do I come across a blog that’s
    both equally educative and amusing, and let me tell you, you have hit the nail on the
    head. The problem is something that too few men and women are speaking intelligently about.
    I’m very happy I found this during my hunt for something regarding this.

    Check out my site Eternal Nutrition Male Enhancement Reviews

  11. online casino site

    It’s gambling and I wanted to uncover an acceptable way to
    achieve a greater ROI.

  12. 영화 인턴

    Please let me know if you’re looking for a article author for your blog.
    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 absolutely
    love to write some content for your blog in exchange for a link back to
    mine. Please send me an email if interested. Thanks!

  13. best deals

    Thanks for some other wonderful post. The place else may just anybody get that kind of information in such a perfect means of writing? I’ve a presentation subsequent week, and I’m on the search for such information.

  14. xxx mom son fuck HD movies

    Ahaa, its fastidious dialogue concerning this article
    here at this webpage, I have read all that, so now me also commenting at this place.

  15. Bloom Green CBD

    I blog frequently and I genuinely appreciate your
    content. The article has truly peaked my interest.
    I am going to bookmark your site and keep checking for new information about once a week.
    I opted in for your RSS feed too.

    Here is my web site: Bloom Green CBD

  16. 토렌트 왈

    Hi great blog! Does running a blog like this take a massive amount work?
    I’ve absolutely no understanding of programming however I was hoping to start my own blog
    in the near future. Anyhow, if you have any ideas or tips
    for new blog owners please share. I understand this is off
    subject nevertheless I just needed to ask. Appreciate it!

  17. IconaGlow Review

    I like the helpful info you provide in your articles.
    I will bookmark your weblog and check again here frequently.
    I am quite certain I’ll learn plenty of new stuff right here!
    Good luck for the next!

    Check out my webpage :: IconaGlow Review

  18. 맥 유튜브 다운로드

    Piece of writing writing is also a excitement, if you be familiar with after that
    you can write if not it is complex to write.

  19. powerball online check ticket

    Bovada allows sports betting on-line on their user-friendly
    mobile interface or in their state of the art poker
    and casino gaming rooms.

  20. camchatadult.com

    Yes though you’ll find a billion sorts of women in actuality, but for this objective I will
    classify them into two forms. And if you find yourself drawn to a particular model, make sure to
    join their on-site Fan Club to receive updates, discount codes, and more!
    You’ve stepped out on that limb and here you are taking the first
    steps to make that happen. Once you’ve selected your reason for joining, complete
    the membership application, and verify your identity via email, you’ll be able to start
    streaming. Purpose – you must consider the reason for getting the adult
    DVD whether if for you and your partner’s sexual
    gratification or if you happen to be buying
    it for some friend’s leisure. Given the anonymity of the Internet and
    the tools provided with most online dating services to limit undesirable contact, safety must be recognised as a significant
    advantage to online dating over many traditional means of meeting partners.
    Online single dating services are provided by various web
    sites to help singles to meet singles for dating or for
    maintaining long term relationships. How do adult cam sites work?

  21. betting strategies

    This was undesirable news for some on the net
    operators, as Spain was previously akin to the Wild West.

Tinggalkan Balasan

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