Njira 1: Kusintha mawonekedwe a khungu kuti "mawu"
Chochita chosavuta kwambiri chomwe chingatengedwe ngati kuli koyenera kuwonjezera manambala a zeros ndikusintha mtundu wa maselo ofunikira palembali, kotero kuti sakuthanso zovuta ndi kuchotsera kwa zeros yosafunikira. Pakukhazikitsa ichi mu Excel pali menyu yodziwika bwino.
- Nthawi yomweyo sankhani maselo onse ofunikira ndi manambala potseka batani lakumanzere.
- Kunyumba yanyumba, tsegulani "gawo".
- Imbani "Fomu" yotsitsa.
- Mmenemo, dinani pa gulu laposachedwa la mtundu wa cell.
- Windo latsopano latsopano lidzaonekera, komwe kuli kumanzere koloko-dinani "zolemba" kuti mugwiritse ntchito mtundu uwu. Ngati zenera silimangokhala chabe, muchite nokha.
- Bweretsani ku Makhalidwe mu maselo ndikuwonjezera ziros komwe kuli kofunikira. Ganizirani izi ndi makonzedwe amenewo, kuchuluka kwake sikungaganizire tsopano, popeza mawonekedwe a khungu sakhala manambala.
Njira 2: Kupanga mtundu wanu
Njira yabwino kwambiri yomwe ili yoyenera kuyika kwa zeros pamaso pa manambala pomwe pamanja sizikufuna kuchita kapena njirayo itenge nthawi yambiri. Kupanga mtundu wanu kumatheka ngati mukudziwa kuchuluka kwa manambala omwewo ayenera kupezeka, mwachitsanzo, ndi inshuwaransi kapena chizindikiritso chilichonse. Mwachitsanzo, tengani mtundu 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000.
- Sankhani magulu onse omwe ali ndi manambala, tsegulani menyu omwewo kuti akhazikitse maselo ndikupita ku "Fomu Yanu".
- Nthawi iyi, sankhani "(mapangidwe onse)."
- Osagwiritsa ntchito tebulo ndi mitundu, ndipo lembani pamanja kuti chitsanzo chiwope bwino.
- Bwerera patebulo ndikuwonetsetsa kuti zosintha zonse zimagwiritsidwa ntchito bwino.
Njira 3: Sinthani mawonekedwe a cell pafoni
Mukasinthanitsa khungu lina, mutha kugwiritsa ntchito Excel Syntax kuti mupange zolemba. Izi ndizothandiza pazomwe zilipo kuti musinthe mtengo wake mwachangu ndikuwonjezera zeros.
- Pankhaniyi, sankhani khungu ndikuyambitsa munda wake kuti asinthe.
- Ikani chizindikirocho "'" pa chiyambi chopanda danga.
- Pambuyo pa chizindikiro ichi, onjezerani kuchuluka kwa zeros pogwiritsa ntchito malo, ngati kuli kotheka. Dinani ENTER kuti mutsimikizire kusintha.
- Onetsetsani kuti tsopano zomwe zalembedwazo zikuwonetsedwa bwino.
Njira 4: Manambala opanga m'maselo atsopano
Kusintha kotsiriza kowonjezera ma neros patsogolo pa manambala omwe amafotokoza za maselo a cell mu block yatsopano pogwiritsa ntchito lembalo. Ganizirani kuti pamenepa zachitika zatsopano zimapangidwa ndi deta, yomwe idzawonetsedwa pansipa.
- Poyambira, timafotokoza kuchuluka kwa manambala. Mutha kugwiritsa ntchito malo kapena hyphen, zomwe zimatengera mtundu wojambulidwa.
- Mu khungu lopanda kanthu, yambani kulemba formula "= mawu".
- Pambuyo powonjezera mabatani otseguka komanso otsekemera, tchulani khungu kuti lizisintha.
- Onjezani mfundo ya comma kuti mupatule mtengo kuchokera pamtundu.
- Tsegulani nkhani ziwiri ndikulemba, momwe lembalo likuyenera kuwonetsedwa (talankhula kale pamwambapa).
- Dinani batani la Enter ndikuwona zotsatira zake. Monga momwe tingawonekere, mtengo wake umayandikana ndi kuchuluka kwa otchulidwa, ndipo manambala omwe akusowawo amasinthidwa ndi Zes patsogolo, zomwe zimafunikira mukamapanga mndandanda wa zidziwitso, manambala a inshuwaransi ndi zambiri.
Monga chidziwitso chowonjezera, timalimbikitsa kuti zidziwe zomwe zikugwirizana patsamba lathu, zomwe zingakhale zothandiza mukamayang'ana maselo komanso kugwiritsa ntchito njira zina.
Wonenaninso:
Chotsani Zero Phunziro mu Microsoft Excel
Kuchotsa kusiyana pakati pa manambala ku Microsoft Excel