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

  1. online casino

    Undeniably consider that which you said. Your favourite justification seemed to be
    at the internet the simplest factor to take into account of.
    I say to you, I certainly get annoyed at the same time as folks think
    about issues that they plainly do not recognise about.
    You controlled to hit the nail upon the highest and outlined out the entire thing
    without having side-effects , folks can take a
    signal. Will probably be back to get more. Thanks

  2. Previous Bitcoin Bull Run Patterns Suggest Current Run Could See a $160K Top

    Howdy I am so thrilled I found your blog page, I really found you by mistake, while I was searching on Aol for something
    else, Regardless I am here now and would just like to say many thanks for a tremendous post and a all
    round interesting blog (I also love the theme/design),
    I don’t have time to read it all at the moment but I have bookmarked 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 excellent work.

  3. เว็บแทงมวยออนไลน์

    Its like you read my thoughts! You appear to understand so much about
    this, like you wrote the e-book in it or something. I believe that
    you simply can do with a few p.c. to force the message house a bit,
    however other than that, this is magnificent blog. A great read.
    I’ll definitely be back.

  4. Brook

    Excellent items from you, man. I’ve consider your stuff prior to and you are just extremely magnificent.
    I actually like what you’ve got here, certainly like what you’re saying and the best way through which
    you say it. You make it entertaining and you still care
    for to stay it sensible. I can’t wait to read much more from you.
    This is really a tremendous website.

  5. 유튜브 영상 다운로더

    I am extremely impressed with your writing skills and also with the
    layout on your weblog. Is this a paid theme or did you modify it yourself?
    Either way keep up the nice quality writing, it’s rare to
    see a nice blog like this one nowadays.

  6. AdultFrinendFinder

    wonderful post, very informative. I’m wondering why the opposite specialists of this
    sector don’t realize this. You must proceed your writing.
    I am confident, you have a great readers’ base already!

  7. 먹튀

    I’m not certain where you are getting your info, however great
    topic. I needs to spend a while learning more
    or understanding more. Thank you for magnificent information I used to be
    in search of this information for my mission.

  8. genital hair removal

    Other states have not entered into these agreements and
    have rather restricted gambling to riverboats.

  9. 모바일 토렌트 추천

    Thanks designed for sharing such a nice thought, paragraph is fastidious, thats why i have
    read it fully

  10. Miakam

    [url=https://prednisoneprednisolone.com/]prednisone 2018[/url] [url=https://tetracyclineonline.com/]purchase tetracycline online[/url] [url=https://oipharmacy.com/]best canadian pharmacy[/url] [url=https://elitadalafil.com/]tadalafil 20 mg chewable[/url] [url=https://hicialis.com/]how to get cialis in australia[/url]

  11. Shelly

    Thanks for the auspicious writeup. It actually used to be
    a amusement account it. Look complex to more delivered agreeable from you!
    By the way, how could we keep up a correspondence?

  12. 울산출장마사지

    This website was… how do you say it? Relevant!! Finally I have found something that helped me. Many thanks!

  13. Lashunda

    Howdy terrific website! Does running a blog such as this
    take a lot of work? I’ve no knowledge of programming but I was hoping to start my own blog
    in the near future. Anyway, should you have any suggestions or
    techniques for new blog owners please share. I know this is off subject but I simply needed to
    ask. Kudos!

  14. Casino

    Today, I went to the beach front with my kids. I found a sea shell and gave
    it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed the
    shell to her ear and screamed. There was a hermit crab inside and it pinched her
    ear. She never wants to go back! LoL I know this is entirely off topic
    but I had to tell someone!

  15. 유튜브 영상 자르기

    Thank you for the auspicious writeup. It in fact was a amusement account it.
    Look advanced to more added agreeable from
    you! However, how could we communicate?

  16. online bets

    Federation officials could not be reached for comment by ESPN.

  17. 부산출장

    Having read this I thought it was extremely informative. I appreciate you finding the time and effort to put this content together. I once again find myself personally spending a lot of time both reading and commenting. But so what, it was still worth it!

  18. 10 reason to learn english

    I enjoy what you guys tend to be up too. This
    type of clever work and exposure! Keep up the wonderful works guys I’ve incorporated you guys to my personal blogroll.

  19. fotowoltaika katowice

    My brother recommended I might like this website. He was totally right. This post truly made my day. You cann’t imagine just how much time I had spent for this info! Thanks!

  20. vacuum glove box

    What’s up i am kavin, its my first occasion to commenting anyplace,
    when i read this post i thought i could also make comment due to this brilliant post.

Tinggalkan Balasan

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