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.
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”.
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.
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”.
Pada tab “Number”, pilih “Custom” pada list Category, lalu ketik 00000 pada kolom Type.
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.
Kamu bisa mainkan lebih lanjut lagi sesuai kebutuhan untuk mendapatkan tipe formatting yang paling tepat.
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
KidsBrandStore Rabattcode
CE
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.
เว็บแทงมวยออนไลน์
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.
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.
chuyển hàng đi đức giá rẻ
It’s very effortless to find out any matter on web as compared to textbooks,
as I found this post at this website.
유튜브 영상 다운로더
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.
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!
윈도우10 정품 키 확인
This is my first time pay a visit at here and i am really impressed to read all at alone place.
먹튀
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.
genital hair removal
Other states have not entered into these agreements and
have rather restricted gambling to riverboats.
모바일 토렌트 추천
Thanks designed for sharing such a nice thought, paragraph is fastidious, thats why i have
read it fully
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]
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?
Tinder dating site
tindr , what is tinder https://tinderdatingsiteus.com/
울산출장마사지
This website was… how do you say it? Relevant!! Finally I have found something that helped me. Many thanks!
Ekspedisi Surabaya
Arms, Foil and HogWhat good sports
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!
Tankless Water Heater Installation in johnstown
Does your blog have a contact page? I’m having trouble locating
it but, I’d like to send you an email. I’ve got some recommendations for
your blog you might be interested in hearing. Either way, great blog and I look forward to seeing it develop over time.
Feel free to surf to my blog post – Tankless Water Heater Installation in johnstown
how does it cost to rent a carpet cleaner
Keep working ,remarkable job!
Also visit my web site; how does it cost to rent a carpet cleaner
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!
유튜브 영상 자르기
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?
Roofers in Ipswich
bookmarked!!, I really like your blog!
online bets
Federation officials could not be reached for comment by ESPN.
부산출장
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!
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.
พุทธเจ้า 5 พระองค์ แห่งโลกธาตุ
excellent post, very informative. I’m wondering why the other experts of this sector do not understand this.
You must continue your writing. I’m confident, you’ve a great
readers’ base already!
Tankless Water Heater Installation in sumter
This is the right web site for anybody who hopes to understand this topic.
You realize so much its almost hard to argue
with you (not that I personally would want to…HaHa).
You certainly put a fresh spin on a subject which has been discussed for a long time.
Wonderful stuff, just wonderful!
My page Tankless Water Heater Installation in sumter
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!
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.