Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel

Ekubaleni okuthile, izinombolo zesi-Arabhu zivame ukusetshenziswa, kodwa kwezinye izimo kudingeka izinombolo zesiRoma (isibonelo, ukukhombisa izinombolo zesahluko nezigaba ezincwadini, emibhalweni, njll.). Iqiniso liwukuthi azikho izinhlamvu ezikhethekile kukhibhodi yekhompyutha, kodwa usengakwazi ukubhala izinombolo zesiRoman. Ake sibone ukuthi lokhu kwenziwa kanjani ku-Excel.

Okuqukethwe

Ukubhala Izinombolo ZamaRoma

Okokuqala sidinga ukunquma ukuthi ncamashi kangakanani futhi kangaki sifuna ukusebenzisa izinombolo Roman. Uma lesi kuyisidingo sesikhathi esisodwa, inkinga ixazululwa kalula ngokufaka izinhlamvu ngesandla kusuka kukhibhodi. Kodwa uma uhlu lwezinombolo lukhulu, umsebenzi okhethekile uzosiza.

Okokufaka mathupha

Konke kulula kakhulu - i-alfabhethi yesiLatini iqukethe zonke izinombolo zesiRoma. Ngakho-ke, simane sishintshele kusakhiwo sesiNgisi (I-Alt + Shift or I-Ctrl + Shift), sithola kukhibhodi ukhiye onohlamvu oluhambisana nenombolo yesiRoman, futhi ubambe ukhiye Shift, cindezela. Uma kudingeka, faka inombolo elandelayo (okungukuthi uhlamvu) ngendlela efanayo. Cindezela uma usulungile Faka.

Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel

Uma kunezinhlamvu eziningana, ukuze ungabambi isikhathi ngasinye Shift, ungavele uvule imodi Bheka Ofeleba (ungakhohlwa ukuyivala ngokuhamba kwesikhathi).

Qaphela: Izinombolo zesi-Roman azikwazi ukubamba iqhaza ekubalweni kwezibalo ezenziwa ku-Excel, ngoba uhlelo kulokhu lungakwazi ukubona isipelingi sazo sesi-Arabhu.

Ukufaka uphawu

Le ndlela ayivamile ukusetshenziswa, ikakhulukazi uma ngesizathu esithile ikhibhodi ingasebenzi noma ingaxhunyiwe. Kodwa isekhona, ngakho sizoyichaza.

  1. Sima kuseli lapho sifuna ukufaka khona inombolo. Bese kuthebhu "Faka" chofoza isithonjana “Isimboli” (iqembu lamathuluzi "Izimpawu").Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel
  2. Iwindi lizovuleka lapho ithebhu izosebenza ngokuzenzakalelayo. "Izimpawu". Lapha singasetha ifonti esiyithandayo (chofoza inketho yamanje bese ukhetha ohlwini oluhlongozwayo).Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel
  3. Okwepharamitha "Ikhithi" ngendlela efanayo, sikhetha inketho - "Basic Latin".Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel
  4. Manje vele uchofoze uphawu olufunayo emkhakheni ongezansi, bese uchofoza "Faka" (noma vele uchofoze kabili kukho). Uphawu luzovela kuseli ekhethiwe. Lapho okokufaka sekuqediwe, vala iwindi ngokucindezela inkinobho ehambisanayo.Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel

Ukusebenzisa umsebenzi

I-Excel inomsebenzi okhethekile wezinombolo zesiRoman. Abasebenzisi abanolwazi bangayibhala ngokuqondile kubha yefomula. I-syntax yayo ibukeka kanje:

=I-ROMAN(inombolo,[ifomu])

Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel

Kudingeka ipharamitha kuphela "Inombolo" - lapha siphrinta inombolo yesi-Arabhu, okudingeka iguqulwe ibe isiRoman. Futhi, esikhundleni senani elithile, ireferensi yeseli ingacaciswa.

Ukungqubuzana "ifomu" ozikhethela (ikuvumela ukuthi unqume uhlobo lwenombolo ku-Roman notation).

Nokho, ijwayeleke kakhulu futhi kulula kubasebenzisi abaningi ukuyisebenzisa Umsebenzi Wizards.

  1. Sisukuma esitokisini esifunayo bese sichofoza isithonjana sokufaka "Fx" kwesokunxele sebha yefomula.Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel
  2. Ngokukhetha isigaba “Uhlu oluphelele lwama-alfabhethi” thola intambo "ROMAN", imake, bese ucindezela OK.Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel
  3. Iwindi lokugcwalisa ukuphikisana komsebenzi lizovela esikrinini. Ensimini "Inombolo" faka inombolo yesi-Arabhu noma ubonise isixhumanisi seseli eliqukethe (sibhala mathupha noma simane sichofoze into esiyifunayo kuthebula ngokwalo). I-agumenti yesibili ayivamisile ukugcwaliswa, ngakho vele ucindezele OK.Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel
  4. Umphumela osesimweni senombolo yesi-Roman uzovela kuseli elikhethiwe, futhi okufakiwe okuhambisanayo nakho kuzoba kubha yefomula.Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel

Izinzuzo ezingokoqobo

Sibonga umsebenzi "ROMAN" ungaguqula amaseli amaningana ngesikhathi esisodwa, ukuze ungenzi inqubo mathupha ngayinye yazo.

Ake sithi sinekholomu enezinombolo zesi-Arabhu.

Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel

Ukuze uthole ikholomu namaRoma, yenza lezi zinyathelo ezilandelayo:

  1. Ukusebenzisa umsebenzi "ROMAN" yenza ukuguqulwa kweseli lokuqala noma yikuphi, kodwa okungcono emugqeni ofanayo.Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel
  2. Sihambisa phezulu ekhoneni elingezansi kwesokudla seseli ngomphumela, futhi ngokushesha nje lapho kuvela isiphambano esimnyama (umaka wokugcwalisa), inkinobho yegundane engakwesokunxele ibanjwe phansi, idonsele phansi emgqeni wokugcina oqukethe idatha.Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel
  3. Lapho nje sikhulula inkinobho yegundane, izinombolo zoqobo kukholamu entsha ziguqulelwa ngokuzenzakalelayo zibe isi-Roman.Ukufaka nokunamathisela izinombolo zesi-Roman ku-Excel

Isiphetho

Ngakho-ke, ku-Excel kunezindlela eziningana ezihlukene ongabhala ngazo noma unamathisele izinombolo zesiRoma kumaseli wedokhumenti. Ukukhethwa kwendlela eyodwa noma enye kuncike olwazini nasemakhonweni omsebenzisi, kanye nenani lolwazi olucutshungulwayo.

shiya impendulo