Pali nthawi pamene, pamene mukugwira ntchito ku Excel, mutalowa nambala mu selo, imasonyezedwa ngati tsiku. Izi ndizokhumudwitsa makamaka ngati mukufuna kulowa deta ya mtundu wina, ndipo wosuta sakudziwa momwe angachitire. Tiyeni tiwone chifukwa chake mu Excel, mmalo mwa manambala, tsikulo likuwonetsedwa, komanso mudziwe momwe mungathetsere vutoli.
Kuthetsa vuto la kusonyeza manambala monga masiku
Chifukwa chokha chomwe deta mu selo ikhoza kusonyezedwa ngati tsiku ndiloti liri ndi mawonekedwe oyenerera. Choncho, kuti asinthe mawonetsedwe a deta monga momwe akufunira, wogwiritsa ntchito ayenera kusintha. Mungathe kuchita izi m'njira zingapo.
Njira 1: mndandanda wamakono
Ambiri ogwiritsira ntchito akugwiritsa ntchito masanjidwe ozungulira pa ntchitoyi.
- Dinani molondola pazomwe mukufuna kusintha maonekedwe. Mu menyu a mauthenga omwe amapezeka pambuyo pa zochitikazi, sankhani chinthucho "Sungani maselo ...".
- Zowonetsera zojambula zimatsegula. Pitani ku tabu "Nambala"ngati mwadzidzidzi anatsegulidwa mu tabu ina. Tiyenera kusintha parameter "Maofomu Owerengeka" kuchokera ku tanthauzo "Tsiku" kwa wosuta woyenera. Nthawi zambiri izi ndizofunika "General", "Numeric", "Ndalama", "Malembo"koma pangakhale ena. Zonse zimatengera mkhalidwe weniweni ndi cholinga cha deta yopereka. Pambuyo kusinthani parameter, dinani pa batani "Chabwino".
Pambuyo pake, deta mu maselo osankhidwa sichidzawonetsedwanso ngati tsiku, koma idzawonetsedwa mu mtundu wolondola wa wosuta. Ndiko kuti, cholinga chidzakwaniritsidwa.
Njira 2: Sinthani kukonza pa tepi
Njira yachiwiri ndi yophweka kuposa yoyamba, ngakhale pazifukwa zina zosadziwika kwambiri pakati pa ogwiritsa ntchito.
- Sankhani selo kapena ukhale ndi mtundu wa tsiku.
- Kukhala mu tab "Kunyumba" mu chigawo cha zipangizo "Nambala" Tsegulani munda wapadera wokometsera. Icho chimapanga mawonekedwe otchuka kwambiri. Sankhani yomwe ili yoyenera kwambiri pa deta yeniyeni.
- Ngati pakati pa omwe akuwonetsedwa mndandanda umene sunafuneke, sungani pa chinthucho "Maonekedwe ena amtundu ..." m'ndandanda womwewo.
- Amatsegula mawindo omwe akukonzekera maonekedwe ngati njira yapitayi. Pali mndandanda wambiri wa kusintha kotheka mu deta mu selo. Choncho, zochitika zina zidzakhalanso chimodzimodzi ndi njira yoyamba ya vutolo. Sankhani chinthu chomwe mukufuna ndipo dinani pa batani. "Chabwino".
Pambuyo pake, mtundu wa maselo osankhidwa udzasinthidwa kukhala womwe ukusowa. Tsopano chiwerengero mwa iwo sichingawonetsedwe ngati tsiku, koma chidzatenga mawonekedwe omwe akufotokozedwa ndi wogwiritsa ntchito.
Monga mukuonera, vuto lowonetsera tsikulo mu maselo m'malo mwa nambala si nkhani yovuta kwambiri. Kulikonza ndi lophweka, chabe mbewa imasintha. Ngati wogwiritsa ntchitoyo akudziwa njira zogwirira ntchito, ndiye kuti njirayi imakhala yoyambira. Mungathe kuchita zimenezi m'njira ziwiri, koma zonsezi zimachepetsedwa kukhala kusintha kwa selo kuyambira tsiku lirilonse.
