Haddii aad isku dayayso inaad ku qorto nambar Excel ama Google Sheets oo ka bilaabma eber (0), waxaa laga yaabaa inaadan taas samayn sababtoo ah goobaha caadiga ah. Xaaladdaas, waa inaad raacdaa casharkan si aad eber u geliso ka hor lambarka Google Sheets iyo Microsoft Excel^{(enter zero before a number in Google Sheets and Microsoft Excel)} . Looma baahna wax-ku-kordhin dhinac saddexaad ah si loo sameeyo.

Microsoft Excel iyo Google Sheets waa laba qalab oo nafta badbaadiya oo kaa caawinaya inaad abuurto xaashi xog kala duwan leh. Sida qalabka kale, waxay leeyihiin xaddidaadyo ama arrimo sidoo kale. Tusaale ahaan, isticmaalayaashu ma qori karaan lambar sidan oo kale ah - 00123 ama 000012 ama wax la mid ah. Dhib ma laha safka ama tiirka aad doorato; ma geli kartid tirooyinkaas mid ka mid ah qalabka. Si kastaba ha ahaatee, mararka qaarkood, waxaa laga yaabaa inaad u baahato inaad taas sameyso markaad qorayso zipcode, darajo ama wax kale. Taas awgeed, waa inaad raacdaa xeeladahan aan halkan ku soo sheegnay. Inta badan waxaa jira laba siyaabood oo kala duwan oo loo galo eber ka hor nambarka Google Sheets iyo Microsoft Excel .

Sida Zero loogu daro lambarka hortiisa ee Excel & Google Sheets

Si aad eber ugu darto nambar ka horreeya Google Sheets iyo Excel , raac tillaabooyinkan-

Isticmaal^(Use) warqad-sheegid ka hor intaadan qorin nambar
Beddel qaabaynta unugga

1] Isticmaal^(Use) warqad-sheegid ka hor intaadan qorin nambar

Waa habka ugu fudud ee lagu heli karo shaqada, waxaadna ku isticmaali kartaa farsamadan Google Sheets iyo sidoo kale Microsoft Excel . Uma baahnid inaad wax kale samayso marka laga reebo inaad ku qorto warqadda rasuul ka hor intaanad qorin tirooyinka. Tusaale ahaan, waxaad rabtaa inaad qol ku dhex qorto 00123. Si taas loo sameeyo, waa inaad doorataa unugga oo ku qor kan – 00123.

Sida Zero loogu daro lambarka hortiisa ee Excel iyo Google Sheets

Waxa ay meesha ka saartaa qaabaynta caadiga ah ee unugga waxayna kuu ogolaanaysaa inaad ku qorto tirada oo dhan eber bilawga.

2] Beddel habaynta unugga

Haddii aad u baahan tahay inaad qorto tiro badan oo habka ugu horreeya uu u muuqdo waqti kugu qaadasho, waa inaad beddeshaa qaabka unugga. Habkaas, waxay kuu ogolaanaysaa inaad wax ku qorto qoraal cad. Si taas loo sameeyo, dooro unug ama tiirka oo dhan, tag Format > Number > Plain text cad .

Hadda waxaad qori kartaa lambar kasta oo aad rabto. Macluumaadkaaga, tillaabooyinkan waxay khuseeyaan Xaashiyaha Google^{(Google Sheets)} . Haddii aad isticmaalayso Microsoft Excel , waa in aad ka heshaa doorashooyin isku mid ah meel kale.

Hubi inaad ku jirto tabka Guriga . ^{(Home )}Hadda, hel qaybta lambarka^{(Number )} oo ka dooro qoraalka^(Text) liiska hoos-u-dhaca ee ay u kala horreeyaan.

Hadda wixii ka dambeeya, waxaad ku qori kartaa lambar kasta oo aad rabto.

Waxa ugu fiican ee ku saabsan habka labaad waa in aad dooran karto qaabab kala duwan unugyo kala duwan oo aad ku dari karto gelitaano kala duwan.

How to add Zero in front of number in Excel and Google Sheets

If yоu are trying to write a number in Excel or Google Sheets that starts with zero (0), уou may not do that due to the dеfault settingѕ. In that case, you should follow this tutorial to enter zero before a number in Google Sheets and Microsoft Excel. No third-party add-on is required to get it done.

Microsoft Excel and Google Sheets are two life-saving tools that help you create a spreadsheet with different data. Like other tools, they have some limitations or issues too. For example, users cannot write a number like this – 00123 or 000012 or anything like that. It doesn’t matter which row or column you choose; you cannot enter such numbers in either of the tools. However, sometimes, you may need to do that while writing a zipcode, rank or anything else. For that, you should follow these tricks that we mentioned here. There are mainly two different ways to enter zero before a number in Google Sheets and Microsoft Excel.

How to add Zero in front of number in Excel & Google Sheets

To add a zero before a number in Google Sheets and Excel, follow these steps-

Use an apostrophe before writing a number
Change cell formatting

1] Use an apostrophe before writing a number

It is the easiest method to get the job done, and you can use this technique in Google Sheets as well as Microsoft Excel. You do not need to do anything else apart from typing an apostrophe before writing the numbers. For instance, you want to write 00123 in a cell. To do that, you must select the cell and type this – 00123.

How to add Zero in front of number in Excel and Google Sheets

It removes the default formatting of the cell and allows you to write the whole number with zero in the beginning.

2] Change cell formatting

If you need to write a lot of numbers and the first method seems time consuming for you, you should change the cell formatting. That way, it will let you write anything in plain text. To do so, select a cell or the whole column, go to Format > Number > Plain text.

Now you can write any number you want. For your information, these steps apply to Google Sheets. If you are using Microsoft Excel, you should find the same options in a different place.

Make sure that you are on the Home tab. Now, find the Number section and select Text from the respective drop-down menu.

From now onwards, you can type any number you want.

The best thing about the second method is that you can choose different styles for different cells and keep adding various entries.

Caleb Clark

About the author

Waxaan ahay khabiir kombuyuutar, waxaanan ku takhasusay aaladaha iOS. Waxaan dadka caawinayay tan iyo 2009, waayo-aragnimadayda wax-soo-saarka Apple ayaa iga dhigaysa qofka ugu habboon ee ka caawinaya baahiyahooda tignoolajiyada. Xirfadeyda waxaa ka mid ah: - Dayactirka iyo cusboonaysiinta iPhones iyo iPod-yada -Rakida iyo isticmaalka software Apple - Ka caawinta dadka inay helaan apps-ka ugu fiican ee iPhones iyo iPod-yada - Ka shaqaynta mashaariicda onlaynka ah

Sida Zero loogu daro lambarka hortiisa ee Excel iyo Google Sheets

Sida Zero loogu daro lambarka hortiisa ee Excel & Google Sheets