Ungabeka njani i-zero phambi kwenani le-Excel

Indlela yoku-1: Ukutshintsha ifomathi yeseli "kwitekisi"

Inyathelo elilula elinokuthathwa ukuba liyimfuneko ukongeza amanani ee-zeros kukutshintsha ifomathi yeeseli eziyimfuneko kwisicatshulwa, ukuze kungasafumani naziphi na iingxaki ze-zeros ezizenzekelayo. Kuleseto kwi-Excel kukho imenyu ekhethekileyo.

1. Ngokukhawuleza khetha zonke iiseli ezifunekayo kunye neenombolo ngokuvala iqhosha lemouse lasekhohlo.



2. Kwithebhu yasekhaya, vula icandelo "leseli".



3. Fowunela "ifomathi" yemenyu eyehlileyo.



4. Kuyo, cofa kudidi lwamva lwefomathi yeseli.



5. Ifomathi yefomathi entsha iya kuvela, apho kwibhlokhi yasekhohlo-cofa kabini "Itekisi" ukufaka olu hlobo. Ukuba iwindow ayivali ngokuzenzekelayo, yenza ngokwakho.



6. Buyela kumaxabiso kwiiseli kwaye wongeze zeros apho kufuneka khona. Cinga ukuba ngokuseta okunjalo, isixa eso asiyi kuqwalaselwa ngoku, kuba ifomathi yeseli ayisiyo mali.

Indlela 2: Ukwenza ifomathi yakho yeseli

Eyona ndlela ifanelekileyo elungele ukufakelwa kwe-zeros ezizenzekelayo phambi kwamanani xa kusenziwa ngesandla afuna ukwenza okanye inkqubo iza kuthatha ixesha elininzi. Ukwenza ifomathi yakho yeseli kunokwenzeka ukuba ekuqaleni uyayazi indlela amanani ekufuneka abekwe ngayo, umzekelo, ngekhowudi ye-inshurensi okanye nasiphi na isikhombi. Umzekelo, thatha uhlobo 000 000 000 000.

1. Khetha zonke iibhloko ezifihlakeleyo ngamanani, vula imenyu ye-eyehlayo efanayo ukuseta iiseli kwaye uye kwifomathi yeseli ".



2. Ngeli xesha, khetha "(zonke iifomati)."



3. Sukusebenzisa itafile ngeentlobo, kwaye ugcwalise ngesandla ukuze isampulu ifumane umbono ofanelekileyo.



4. Buyela etafileni kwaye uqiniseke ukuba zonke iisetingi zisetyenziswa ngempumelelo.

Indlela 3: Ukutshintsha ngokukhawuleza kwefomathi kwitekisi

Xa uhlela iseli ethile, unokusebenzisa i-Excel syntax ukulungisa isicatshulwa. Oku kuluncedo kwimeko yangoku ukukhawulezisa ixabiso lexabiso kwaye wongeze ze-zeros.

1. Kule meko, khetha iseli kwaye usebenze intsimi yayo ukuba itshintshe.



2. Beka uphawu "'ekuqalekeni ngaphandle kwendawo.



3. Emva kwalo mqondiso, yongeza inani elifunekayo le-zeros usebenzisa izithuba, ukuba kukho imfuneko. Cinezela ENTER ukuqinisekisa utshintsho.



4. Qiniseka ukuba ngoku iziqulatho ziboniswe ngokuchanekileyo.

Indlela 4: Ukufomatha amanani kwiiseli ezintsha

Ukwahluka okokugqibela ukongeza ii-zeros phambi kwamanani e-Excel kuthetha ukufomatha komxholo weseli kwibhloko entsha usebenzisa umsebenzi wesicatshulwa. Cinga ukuba kule meko iiseli ezintsha zenziwe ngedatha, eya kuboniswa ngezantsi.

1. Ukuqala, sichaza inani lamanani. Ungasebenzisa izithuba okanye i-hyphen, exhomekeke kuhlobo olufunekayo lokurekhoda.



2. Kwiseli engenanto, qala ukubhala ifomula "= isicatshulwa".



3. Emva kongeza iibakaki ezivulekileyo kunye nokuvala iibrakethi, chaza iseli yokufomatha.



4. Yongeza indawo yekhoma yokwahlula ixabiso kwifomathi.



5. Vula iikowuti ezimbini kwaye ubhale, loluphi uhlobo lwesicatshulwa kufuneka kuboniswe (sele sithethile ngaphezulu).



6. Cofa iqhosha le-ENTO kwaye ujonge iziphumo. Njengoko kunokubonwa, ixabiso likufuphi nenani labalinganiswa, kwaye amanani ashiyekileyo athathelwa indawo yi-zeros ngaphambili, efunekayo xa kufakwa uluhlu lweempawu, iinombolo zeinshurensi kunye nolunye ulwazi.

Njengolwazi olongezelelekileyo, sicebisa ukuba siziqhelanise namanye amanqaku amabini axhasayo kwiwebhusayithi yethu, eya kuba luncedo xa kufomatha imixholo yeeseli nokusetyenziswa kweefomula.

Bona kwakho:

Susa amaxabiso zero kwi-Microsoft i-Excel

Ukususa umsantsa phakathi kwamanani kwi-Microsoft Excel