Kuisa nekunamisa manhamba echiRoma muExcel

Pakuverengera chimwe chinhu, nhamba dzechiArab dzinowanzoshandiswa, asi pane dzimwe nguva nhamba dzechiRoma dzinodiwa panzvimbo (somuenzaniso, kuratidza chitsauko nenhamba dzechikamu mumabhuku, zvinyorwa, nezvimwewo). Icho chokwadi ndechekuti hapana akakosha mavara pakhibhodi yekombuta, asi iwe unogona kunyora manhamba echiRoman. Ngationei kuti izvi zvinoitwa sei muExcel.

gutsikana

Kunyora Manumera echiRoman

Kutanga, tinofanira kusarudza kuti sei chaizvo uye kakawanda sei tinoda kushandisa nhamba dzeRoma. Kana ichi chiri chido chenguva imwe chete, nyaya yacho inogadziriswa zviri nyore nekuisa mavara kubva pane keyboard. Asi kana rondedzero yenhamba yakakura, basa rakakosha rinobatsira.

Kuisa nemaoko

Zvese zviri nyore - alphabet yechiLatin ine manhamba ese echiRoma. Naizvozvo, isu tinongochinjira kuchimiro cheChirungu (Alt+Shift or Ctrl+Shift), tinowana pakiibhodhi kiyi ine tsamba inoenderana nenhamba yeRoma, uye yakabata kiyi kusuduruka, dzvanya. Kana zvichidiwa, isa nhamba inotevera (kureva tsamba) nenzira imwecheteyo. Dzvanya kana wagadzirira pinda.

Kuisa nekunamisa manhamba echiRoma muExcel

Kana pane mabhii akati wandei, kuitira kuti usabate nguva imwe neimwe kusuduruka, unogona kungobatidza modhi Caps Tarisa (usakanganwa kuidzima gare gare).

Cherechedza: Nhamba dzechiRoman hadzigone kutora chikamu mukuverenga kwemasvomhu kunoitwa muExcel, nekuti chirongwa munyaya iyi chinongogona kuona chiperengo chavo chechiArab.

Kupinza chiratidzo

Iyi nzira haiwanzo kushandiswa, kunyanya kana nekuda kwechimwe chikonzero iyo keyboard isingashande kana isina kubatana. Asi zvichiripo, saka tichazvitsanangura.

  1. Tinomira murusero umo tinoda kuisa nhamba. Zvadaro mune tab “Isert” tinya pane icon “Simbo” (Tool group "Zviratidzo").Kuisa nekunamisa manhamba echiRoma muExcel
  2. Hwindo rinovhurika umo iyo tebhu ichave inoshanda. "Zviratidzo". Pano tinogona kuseta font yesarudzo yedu (tinya pane yazvino sarudzo uye sarudza kubva pane yakarongwa runyorwa).Kuisa nekunamisa manhamba echiRoma muExcel
  3. For parameter "Kit" nenzira imwecheteyo, tinosarudza sarudzo - "Basic Latin".Kuisa nekunamisa manhamba echiRoma muExcel
  4. Iye zvino ingodzvanya pane yaunoda chiratidzo mundima pazasi, wobva wadzvanya “Isert” (kana kungodzvanya kaviri pairi). Chiratidzo chichaonekwa musero rakasarudzwa. Kana iyo yekuisa yapera, vhara hwindo nekudzvanya bhatani rinoenderana.Kuisa nekunamisa manhamba echiRoma muExcel

Kushandisa basa

Excel ine basa rakakosha renhamba dzechiRoman. Vashandisi vane ruzivo vanogona kuinyora zvakananga mubhari yeformula. Syntax yaro inoita seizvi:

=ROMAN(nhamba,[fomu])

Kuisa nekunamisa manhamba echiRoma muExcel

Chete parameter inodiwa “Nhamba” - pano tinodhinda nhamba yeArabic, inoda kushandurwa kuva chiRoman. Zvakare, pachinzvimbo chehumwe kukosha, chirevo chesero chinogona kutsanangurwa.

Argument "fomu" sarudzo (inokubvumira kuti uone rudzi rwenhamba muRoma notation).

Nekudaro, yakajairika uye iri nyore kune vazhinji vashandisi kushandisa Basa Wizards.

  1. Isu tinosimuka mune yatinoda sero uye tinya pane yekuisa icon "Fx" kuruboshwe rweformula bar.Kuisa nekunamisa manhamba echiRoma muExcel
  2. Nekusarudza chikamu “Runyorwa ruzere rwearufabheti” tsvaga tambo “ROMAN”, maka, wobva wadzvanya OK.Kuisa nekunamisa manhamba echiRoma muExcel
  3. Iwindo rekuzadza mumabasa nharo richaonekwa pachiratidziro. Mumunda “Nhamba” isa nhamba yechiArab kana kuratidza chinongedzo kuchitokisi chine iyo (tinoinyora nemaoko kana kungodzvanya pane chaunoda chiri patafura pachayo). Nharo yechipiri haiwanzozadzwa, saka ingodzvanya OK.Kuisa nekunamisa manhamba echiRoma muExcel
  4. Mhedzisiro muchimiro chenhamba yeRoma ichaonekwa musero rakasarudzwa, uye inopindirana yekupinda ichave zvakare mune formula bar.Kuisa nekunamisa manhamba echiRoma muExcel

Zvibereko zvinoshanda

Kutenda kune basa “ROMAN” iwe unogona kushandura masero akati wandei kamwechete, kuti usaite maitiro nemawoko kune yega yega.

Ngatitii tine koramu ine nhamba dzechiArab.

Kuisa nekunamisa manhamba echiRoma muExcel

Kuti uwane koramu neVaRoma, ita zvinotevera:

  1. Kushandisa basa “ROMAN” ita shanduko yesero rekutanga chero kupi, asi zviri nani mumutsara mumwechete.Kuisa nekunamisa manhamba echiRoma muExcel
  2. Isu tinofamba pamusoro pekona yezasi yekona yesero nechigumisiro, uye pakarepo kana muchinjikwa wakasviba (mucherechedzo wekuzadza) waonekwa, nebhatani rekuruboshwe rakabatwa pasi, dhonza pasi kumutsara wekupedzisira une data.Kuisa nekunamisa manhamba echiRoma muExcel
  3. Patinongoburitsa bhatani rembeva, nhamba dzepakutanga muchikamu chitsva dzinoshandurwa otomatiki kuita chiRoman.Kuisa nekunamisa manhamba echiRoma muExcel

mhedziso

Saka, muExcel kune nzira dzakasiyana siyana dzaunogona kunyora kana kunamira manhamba echiRoma mumasero egwaro. Kusarudzwa kweimwe kana imwe nzira kunoenderana neruzivo uye unyanzvi hwemushandisi, pamwe chete nehuwandu hwemashoko ari kugadziriswa.

Leave a Reply