Momwe mungasinthire momwe Excel imawonetsera manambala opanda pake
Microsoft Excel imawonetsa manambala olakwika okhala ndi chizindikiro chotsogola chochotsa mwachikhazikitso. Ndichizoloŵezi chabwino kupanga manambala olakwika kukhala osavuta kuzindikira, ndipo ngati simukukondwera ndi kusanja kosasinthaku, Excel imapereka njira zingapo zosinthira manambala olakwika.
Excel imapereka njira ziwiri zomangidwira zowonetsera manambala olakwika, komanso mutha kukhazikitsa mtundu wanthawi zonse. Tiyeni tilowe m'madzi.
Sinthani ku njira ina yopangira nambala yolakwika
Chinthu chimodzi choyenera kudziwa apa ndikuti Excel iwonetsa zosankha zingapo zomwe zakhazikitsidwa kutengera dera lanu komanso zilankhulo zanu.
Kwa iwo aku United States, Excel imapereka njira zotsatirazi zopangira kuti ziwonetse manambala oyipa:
- Wakuda wokhala ndi chizindikiro chochotsera m'mbuyomu
- mu red
- mabatani (mutha kusankha ofiira kapena akuda)
Ku UK ndi mayiko ena ambiri aku Europe, nthawi zambiri mumatha kuyika manambala olakwika kuti awonekere zakuda kapena zofiyira kapena opanda chizindikiro chochotsera (mitundu yonse iwiri) koma mulibe kusankha kwa mabatani. Mutha kudziwa zambiri za makonda amderali pa Webusayiti ya Microsoft .
Ziribe kanthu komwe muli, mudzatha kuwonjezera zina mwa kusintha mtundu wa nambala, zomwe tidzakambirana m'gawo lotsatira.
Kuti musinthe kukhala mawonekedwe ena omangidwira, dinani kumanja pa selo (kapena ma cell angapo osankhidwa) ndikudina lamulo la Format Cells. Mukhozanso kukanikiza Ctrl + 1.
Pazenera la Maselo a Format, sinthani kupita ku Nambala tabu. Kumanzere, sankhani gulu la "Nambala". Kumanja, sankhani njira kuchokera pa Negative Nambala mndandanda ndikudina Chabwino.
Dziwani kuti chithunzi chomwe chili pansipa chikuwonetsa zosankha zomwe mumawona ku US. Tikambirana za kupanga masanjidwe anu mu gawo lotsatira, ndiye palibe vuto ngati zomwe mukufuna sizikuwoneka.
Apa, tidasankha kuwonetsa zolakwika zofiira ndi zolembera.
Mawonedwe awa ndi osankhidwa kwambiri kuposa Excel osakhazikika.
Pangani mtundu wa nambala yolakwika
Mutha kupanganso mafomu anu a manambala mu Excel. Izi zimakupatsani kuwongolera kwathunthu momwe deta imawonekera.
Yambani ndikudina kumanja pa selo (kapena ma cell angapo osankhidwa) kenako ndikudina Lamulo la Format Cells. Mukhozanso kukanikiza Ctrl + 1.
Pa Nambala tabu, sankhani gulu la Custom kumanzere.
Mudzawona mndandanda wamitundu yosiyanasiyana kumanja. Izi zingawoneke ngati zosokoneza poyamba koma palibe chifukwa choopa.
Mtundu uliwonse wachikhalidwe umagawidwa mpaka magawo anayi, ndipo gawo lililonse limasiyanitsidwa ndi semicolon.
Gawo loyamba ndi la zinthu zabwino, lachiwiri ndi zokometsera, lachitatu ndi ziro, ndipo gawo lomaliza la mawu. Simukuyenera kukhala ndi magawo onse osinthidwa.
Mwachitsanzo, tiyeni tipange nambala yolakwika yomwe ili ndi zotsatirazi.
- mu blue
- pakati pa mabulaketi
- Palibe malo owerengeka
M'bokosi la Type, lowetsani kachidindo pansipa.
#, ##0; [Buluu] (#, ##0)
Chizindikiro chilichonse chili ndi tanthauzo, ndipo mwanjira iyi, # imayimira kuwonetsa nambala yofunikira, ndipo 0 ndikuwonetsa nambala yosafunikira. Nambala iyi ili m'makolo ndipo imawonetsedwanso mubuluu. Pali mitundu 57 yosiyanasiyana yomwe mungatchule dzina kapena nambala mumtundu wamtundu wamtundu. Kumbukirani kuti semicolon imalekanitsa chiwonetsero cha nambala yabwino ndi yoyipa.
Nazi zotsatira zathu:
Kupanga mwamakonda ndi luso lothandiza mu Excel. Mutha kupanga mawonekedwe omwe amapitilira makonda omwe amapezeka mu Excel omwe sangakhale okwanira pazosowa zanu. Kupanga manambala olakwika ndi chimodzi mwazinthu zomwe zimagwiritsidwa ntchito kwambiri ndi chida ichi.
