Sinthani Malemba ku Nambala Ndi Excel Pangani Zapadera

01 a 04

Sinthani Dongosolo Lofunika Kuchokera pa Text to Number Format

Nthawi zina, pamene zikhalidwe zimatumizidwa kapena zimakopedwa mu Excel zimapangidwira mfundo zomwe zimatha kumapeto monga malemba osati monga chiwerengero cha chiwerengero.

Izi zingayambitse mavuto ngati mayesero amayesedwa kuti athetse deta kapena ngati deta ikugwiritsidwa ntchito pakuwerengera ntchito zina zomwe Excel anakhazikitsa.

Mu chithunzi pamwambapa, mwachitsanzo, ntchito ya SUM yowonjezera mfundo zitatu - 23, 45, ndi 78 - zomwe zili mu maselo D1 mpaka D3.

M'malo mobwezera 146 ngati yankho; Komabe, ntchitoyi imabweretsanso zero chifukwa zikhulupiliro zitatuzi zakhala zikulembedwa monga malemba m'malo mowerengera nambala.

Zomwe Mwapangidwe

Kusintha kwasinthika kwa Excel kwa mitundu yosiyanasiyana ya deta kumakhala nthawi imodzi yowonetsera yomwe imasonyeza pamene deta yatumizidwa kapena kulowa molakwika.

Mwachinsinsi, deta ya chiwerengero, komanso ndondomeko yowonjezera ndi zotsatira, zimayikidwa kumanja kwa selo, pamene malemba akugwirizana kumanzere.

Nambala zitatu - 23, 45, ndi 78 - mu chithunzi pamwambapa zikugwirizana kumbali ya kumanzere kwa maselo awo chifukwa ndi malemba pomwe ntchito ya SUM imalowa mu selo D4 yomwe ili kumanja.

Komanso, Excel kawirikawiri imasonyeza mavuto omwe angakhale nawo mu selo mwa kuwonetsa katatu kakang'ono kobiriwira pamwamba pa ngodya yapamwamba ya selo.

Pachifukwa ichi, katatu kamtunduwu akusonyeza kuti chiwerengero cha maselo D1 mpaka D3 chalembedwera.

Kukonza Mavuto ndi Kuyika Zapadera

Zosankha zosinthira deta iyi kubwereza nambala ndikugwiritsa ntchito VALUE ntchito mu Excel ndikuyika yapadera.

Sakanizani wapadera ndi lamulo lowonjezera la lamulo lopangira zomwe zimakupatsani chisankho chochuluka chokhudza zomwe zimasamutsidwa pakati pa maselo palimodzi .

Zosankhazi zikuphatikizapo masamu ochita masamu monga Kuwonjezera ndi kuchulukitsa.

Lonjezerani Malemba ndi 1 ndi Paste Special

Njira yowonjezera muchisomo chapadera sichidzachulukitsa manambala onse ndi kuchuluka kwake ndikuyika yankho ku selo yopita kumene, koma idzasinthiranso malemba kuti awerengere deta pamene chilolezo chilichonse chikuwonjezeka ndi mtengo wa 1.

Chitsanzo pa tsamba lotsatila chimagwiritsa ntchito mbali iyi ya padera yapadera ndi zotsatira za ntchitoyi:

• yankho la ntchito ya SUM likusintha kuchokera ku zero kufika 146
• mfundo zitatuzi zimasintha kusintha kuchokera kumanzere kwa selo kupita kumanja
• zowonongeka zofiira katatu zikuchotsedwa m'maselo omwe ali ndi deta

02 a 04

Gwiritsani Chitsanzo Chamtengo Wapadera: Kusintha Malemba kwa Numeri

Kuti mutembenuzire malemba kuti muwerengetse deta, ife choyamba tikufunika kulemba manambala monga malemba.

Izi zimachitika polemba apostrophe ( ' ) kutsogolo kwa nambala iliyonse pamene yalowa mu selo.

1. Tsegulani tsamba latsopano mu Excel yomwe ili ndi maselo onse omwe aperekedwa ku General format
2. Dinani pa selo D1 kuti mupange selo yogwira ntchito
3. Lembani apostrophe yotsatira nambala 23 mu selo
4. Dinani ku key lolowamo pa khibhodi
5. Monga momwe tawonera pa chithunzi pamwambapa, selo D1 liyenera kukhala ndi katatu wobiriwira pamwamba pa ngodya yapamwamba ya selo ndipo nambala 23 iyenera kukhala mbali yoyenera. Apostorophe sichiwoneka mu selo
6. Dinani pa selo D2, ngati kuli kofunikira
7. Lembani apostrophe yotsatira nambala 45 mu selo
8. Dinani ku key lolowamo pa khibhodi
9. Dinani pa selo D3
10. Lembani apostrophe yotsatira nambala 78 mu selo
11. Dinani ku key lolowamo pa khibhodi
12. Dinani pa selo E1
13. Lembani nambala 1 (palibe apostrophe) mu selo ndikusindikizira Enter key pa makiyi
14. Chiwerengero cha 1 chiyenera kulumikizidwa kumbali yoyenera ya selo, monga momwe tawonetsera pa chithunzi pamwambapa

Zindikirani: Kuti muwone apostrophe patsogolo pa manambala alowa mu D1 mpaka D3, dinani pa imodzi mwa maselo awa, monga D3. Mu barangidwe lamatabwa pamwamba pa tsamba, zolowera '78 ziyenera kuwonekera.

03 a 04

Gwiritsani Chitsanzo Chapadera: Kutembenuzira Malemba kwa Numeri (Cont.)

Kulowa Ntchito ya SUM

1. Dinani pa selo D4
2. Mtundu = SUM (D1: D3)
3. Dinani ku key lolowamo pa khibhodi
4. Yankho 0 liyenera kuwonedwa mu selo D4, chifukwa chiyero mu maselo D1 mpaka D3 chidalembedwera

Zindikirani: Kuphatikiza pa kujambula, njira zolowera ntchito ya SUM mu selo lopangira ntchito ndizo:

• Makina achingwe
• SUM ntchito ntchito dialog box
• Sakanizani

Kutembenuzira Malemba ku Nambala ndi Kuyika Mwapadera

1. Dinani selo E1 kuti likhale selo yogwira ntchito
2. Pabupi la kunyumba la riboni , dinani pa chithunzi
3. Nyerere zoyenda ziyenera kuyang'ana kuzungulira selo E1 zosonyeza kuti zomwe zili mu seloyi zikukopedwa
4. Onetsetsani maselo D1 mpaka D3
5. Dinani pamsana wotsika pansipa chithunzi choyika Pakhomo la Tsambali kuti mutsegule mapu
6. Mu menyu, dinani Sakani Zapadera kuti mutsegule Bokosi Lalikulu lazokambirana
7. Pansi pa gawo la Opaleshoni la bokosi la bokosi, dinani pawuniyesi pafupi ndi Yambiri kuti muyambe ntchitoyi
8. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito

04 a 04

Gwiritsani Chitsanzo Chapadera: Kutembenuzira Malemba kwa Numeri (Cont.)

Zotsatira Zopangira Zolemba

Monga momwe tawonetsera pa chithunzi pamwambapa, zotsatira za opaleshoniyi mu tsambali ziyenera kukhala:

• mfundo zitatu mu maselo D1 mpaka D3 tsopano ziyenera kulumikizidwa kumanja mu maselo awo
• ma katatu obiriwira ayenera kuchoka kumbali yakumanja ya selo iliyonse
• Zotsatira za ntchito ya SUM mu selo D4 ziyenera kuwerengedwa 146 zomwe zili ndi chiwerengero cha nambala zitatu m'maselo D1 mpaka D3