Kulowetsa ndi kumata manambala achiroma mu Excel

Polembapo manambala, manambala achiarabu amagwiritsidwa ntchito, koma nthawi zina manambala achiroma amafunikira m'malo mwake (mwachitsanzo, kuwonetsa machaputala ndi manambala agawo m'mabuku, zolemba, ndi zina). Chowonadi ndi chakuti palibe zilembo zapadera pa kiyibodi ya pakompyuta, komabe mutha kulemba manambala achiroma. Tiyeni tiwone momwe izi zimachitikira mu Excel.

Kulemba Manambala Achiroma

Choyamba tiyenera kusankha momwe ndendende komanso kangati tikufuna kugwiritsa ntchito manambala achiroma. Ngati ichi ndi chosowa nthawi imodzi, vuto limathetsedwa mosavuta ndikulowetsa zilembo kuchokera pa kiyibodi. Koma ngati mndandanda wa manambala ndi waukulu, ntchito yapadera ingathandize.

Kulowetsa pamanja

Chilichonse ndi chophweka - zilembo za Chilatini zili ndi manambala onse achiroma. Chifukwa chake, timangosinthira kumayendedwe achingerezi (Alt + kuloza or Ctrl + Shift), timapeza pa kiyibodi fungulo lokhala ndi chilembo chofanana ndi nambala yachiroma, ndikugwira fungulo kosangalatsa, dinani. Ngati pakufunika, lowetsani nambala yotsatira (ie chilembo) chimodzimodzi. Dinani pamene mwakonzeka Lowani.

Ngati pali makalata angapo, kuti musagwire nthawi iliyonse kosangalatsa, mukhoza kungoyatsa mode Mawonekedwe a Caps (osayiwala kuzimitsa pambuyo pake).

Zindikirani: Manambala achiroma sangathe kutenga nawo mbali pamawerengedwe a masamu omwe amachitidwa ku Excel, chifukwa pulogalamuyi imatha kuzindikira kalembedwe ka Chiarabu.

Kuyika chizindikiro

Njirayi siigwiritsidwa ntchito kawirikawiri, makamaka ngati pazifukwa zina kiyibodi siigwira ntchito kapena sichikugwirizana. Koma ikadalipo, ndiye tifotokoza.

1. Timayima mu cell yomwe tikufuna kuyikamo nambala. Ndiye mu tabu "Ikani" dinani chizindikirocho "Chizindikiro" (gulu la zida "Zizindikiro").
2. Zenera lidzatsegulidwa momwe tabu idzagwira ntchito. "Zizindikiro". Apa titha kukhazikitsa font yomwe tikufuna (dinani pazomwe zilipo ndikusankha pamndandanda womwe mukufuna).
3. Kwa parameter "Kiti" momwemonso, timasankha njira - "Basic Latin".
4. Tsopano ingodinani pachizindikiro chomwe mukufuna m'gawo lomwe lili pansipa, kenako dinani "Ikani" (kapena kungodinanso kawiri pa izo). Chizindikirocho chidzawonekera mu selo losankhidwa. Pamene athandizira anamaliza, kutseka zenera ndi kukanikiza lolingana batani.

Kugwiritsa ntchito

Excel ili ndi ntchito yapadera ya manambala achi Roma. Ogwiritsa ntchito odziwa bwino amatha kuyilemba mwachindunji mu bar ya formula. Syntax yake ikuwoneka motere:

=ROMAN(nambala,[fomu])

Ndi parameter yokhayo yomwe ikufunika "Nambala" - apa tikusindikiza nambala ya Chiarabu, yomwe iyenera kusinthidwa kukhala Chiroma. Komanso, m'malo mwa mtengo wapadera, kutchulidwa kwa selo kungatchulidwe.

Kutsutsana "fomu" kusankha (zimakupatsani mwayi wodziwa mtundu wa nambala muzolemba zachiroma).

Komabe, ndizodziwika bwino komanso zosavuta kuti ogwiritsa ntchito ambiri azigwiritsa ntchito Ntchito Wizards.

1. Timayimirira mu cell yomwe tikufuna ndikudina chizindikiro choyikapo "Fx" kumanzere kwa formula bar.
2. Posankha gulu “Mndandanda wa zilembo zonse” pezani chingwe "ROMAN", ilembeni, kenako dinani OK.
3. Iwindo lodzaza mikangano yantchito lidzawonekera pazenera. M'munda "Nambala" lowetsani nambala ya Chiarabu kapena sonyezani ulalo wa cell yomwe ili nayo (timalemba pamanja kapena kungodinanso chinthu chomwe mukufuna patebulo lomwe). Mtsutso wachiwiri sudzadzazidwa kawirikawiri, choncho ingosindikizani OK.
4. Zotsatira zamtundu wa nambala yachiroma zidzawonekera mu selo yosankhidwa, ndipo cholembera chofananira chidzakhalanso mu bar ya formula.

Zopindulitsa

Chifukwa cha ntchito "ROMAN" mutha kusintha ma cell angapo nthawi imodzi, kuti musamachite njirayi pamanja pa aliyense wa iwo.

Tiyerekeze kuti tili ndi mzati wokhala ndi manambala achiarabu.

Kuti mupeze gawo ndi Aroma, chitani izi:

1. Kugwiritsa ntchito "ROMAN" chitani kusintha kwa selo loyamba kulikonse, koma makamaka pamzere womwewo.
2. Timasunthira kumunsi kumanja kwa selo ndi zotsatira zake, ndipo mwamsanga mtanda wakuda (wodzaza chikhomo) ukuwonekera, ndi batani lakumanzere la mbewa lomwe likugwira pansi, likokereni mpaka pamzere womaliza womwe uli ndi deta.
3. Tikangomasula batani la mbewa, manambala oyambirira mu gawo latsopano amasinthidwa kukhala Chiroma.

Kutsiliza

Chifukwa chake, mu Excel pali njira zingapo zomwe mungalembe kapena kumata manambala achi Roma m'maselo a zikalata. Kusankhidwa kwa njira imodzi kapena ina kumadalira chidziwitso ndi luso la wogwiritsa ntchito, komanso kuchuluka kwa chidziwitso chomwe chikukonzedwa.