Ungazibeka kanjani zero phambi kwenombolo e-Excel

Indlela 1: Ukushintsha ifomethi yeseli "umbhalo"

Isenzo esilula kunazo zonke esingathathwa uma kunesidingo sokungeza kumanani ama-zeros ukushintsha ifomethi yamaseli adingekayo kumbhalo, ukuze ungabe esahlangabezana nezinkinga ngokususwa okuzenzakalelayo kwama-zeros angenasidingo. Ukuze lokhu kulungiselelwa ku-Excel kunemenyu ekhethwe ngokukhethekile.

1. Ngokushesha khetha wonke amaseli adingekayo ngezinombolo ngokuvala inkinobho yegundane kwesobunxele.



2. Kuthebhu yasekhaya, vula isigaba se- "Cell".



3. Shayela imenyu ethi "format" Drop-Down.



4. Kuyo, chofoza isigaba sakamuva sefomethi yeseli.



5. Kuzovela iwindi elisha lokubeka ifomethi, lapho ku-block yangakwesobunxele Qhafaza kabili "Umbhalo" ukuze usebenzise lolu hlobo. Uma iwindi lingavali ngokuzenzakalelayo, zenzele ngokwakho.



6. Buyela kumanani amaseli bese wengeza ama-zeros lapho kudingeka khona. Cabanga ngalokho ngokusetha okunjalo, inani ngeke libhekwe manje, ngoba ifomethi yeseli akuyona inombolo.

Indlela 2: Ukwakha ifomethi yakho yeseli

Indlela ephelele eyengeziwe efanele ukufakwa kwe-zeros okuzenzakalelayo phambi kwezinombolo lapho kungafuni ukwenza noma inqubo izothatha isikhathi esiningi. Ukwakha ifomethi yeseli yakho kungenzeka uma ekuqaleni uyazi ukuthi izinombolo kufanele zitholakale kanjani, ngokwesibonelo, ngekhodi yomshuwalense noma yisiphi isikhombi. Isibonelo, thatha uhlobo 000 000 000 000.

1. Khetha wonke amabhulokhi enziwe ngezifiso ngezinombolo, vula imenyu yokudonsela phansi efanayo ukusetha amaseli bese uya ku- "for format".



2. Kulokhu, khetha "(wonke amafomethi)."



3. Musa ukusebenzisa itafula nezinhlobo, bese uligcwalisa ngesandla ukuze isampula lizuze umbono olungile.



4. Buyela etafuleni futhi uqiniseke ukuthi zonke izilungiselelo zisetshenziswa ngempumelelo.

Indlela 3: Ifomethi yeseli yokushintsha okusheshayo embhalweni

Lapho uhlela iseli ethile, ungasebenzisa i-Excel Syntax ukuze uqalise umbhalo. Lokhu kuyasiza esimweni samanje ukushintsha ngokushesha inani lenani bese wengeza ama-zeros.

1. Kulokhu, khetha iseli bese wenza kusebenze insimu yayo ukuze ushintshe.



2. Beka isibonakaliso esithi "'" Ekuqaleni ngaphandle kwesikhala.



3. Ngemuva kwalesi sibonakaliso, engeza inani elidingekayo lama-zeros usebenzisa izikhala, uma kunesidingo. Cindezela u-ENTER ukuze uqinisekise izinguquko.



4. Qiniseka ukuthi manje okuqukethwe kukhonjiswa kahle.

Indlela 4: Izinombolo zokufometha kumaseli amasha

Okuhlukile kokungezelela ama-zeros phambi kwezinombolo ku-Excel kusho ukufometha kokuqukethwe kweseli ebhuloki elisha usebenzisa umsebenzi wombhalo. Cabanga ukuthi kuleli cala amaseli amasha adalwe ngedatha, ezokhonjiswa ngezansi.

1. Okokuqala, sichaza inani lezinombolo. Ungasebenzisa izikhala noma i-hyphen, kuya ngohlobo oludingekayo lokurekhoda.



2. Esitokisini esingenalutho, qala ukubhala ifomula "= Umbhalo".



3. Ngemuva kokungeza amabakaki avulekile nokuvala, chaza iseli yokufometha.



4. Faka iphuzu lekhefana ukuze uhlukanise inani lefomethi.



5. Vula izingcaphuno ezimbili eziphindwe kabili bese ubhala, lapho umbhalo kufanele uboniswe khona (sesivele sikhulume ngenhla).



6. Chofoza ukhiye we-ENTER bese ubheka umphumela. Njengoba kungabonakala, inani liseduze nenani lezinhlamvu, futhi izinombolo ezingekho zithathelwa indawo yiZeros phambili, ezidingekayo lapho zihlanganisa uhlu lwezikhombisi, izinombolo zomshuwalense kanye neminye imininingwane.

Njengomininingwane eyengeziwe, sincoma ukuzijwayeza ngezindatshana ezimbili ezisekelayo kwiwebhusayithi yethu, ezizosiza lapho ufometha okuqukethwe kwamangqamuzana kanye nokusetshenziswa kwamafomula.

Bona futhi:

Susa amanani we-zero ku-Microsoft Excel

Ukususa igebe phakathi kwezinombolo ku-Microsoft Excel