Don ƙididdige wani abu, yawanci ana amfani da lambobin Larabci, amma a wasu lokuta ana buƙatar lambobin Roman maimakon (misali, don nuna babi da lambobi a cikin littattafai, takardu, da sauransu). Gaskiyar ita ce, babu wasu haruffa na musamman akan madannai na kwamfuta, amma har yanzu kuna iya rubuta lambobin Roman. Bari mu ga yadda ake yin hakan a cikin Excel.
Rubutun Lambobin Roman
Da farko muna buƙatar yanke shawarar yadda daidai da sau nawa muke son amfani da lambobin Roman. Idan wannan buƙatu ce ta lokaci ɗaya, ana warware matsalar ta hanyar shigar da haruffa da hannu daga madannai. Amma idan lissafin lambobi yana da girma, aiki na musamman zai taimaka.
Shigar da hannu
Komai abu ne mai sauqi qwarai – haruffan Latin sun ƙunshi duk lambobin Roman. Don haka, kawai mu canza zuwa shimfidar Turanci (Alt+ Shift or Ctrl+Shift), mun sami maɓalli a madannai mai maɓalli mai harafin da ya yi daidai da lambar Romawa, kuma yana riƙe da maɓallin Motsi, danna shi. Idan an buƙata, shigar da lamba ta gaba (watau harafi) kamar haka. Danna lokacin da aka shirya Shigar.
Idan akwai haruffa da yawa, don kada a riƙe kowane lokaci Motsi, zaka iya kunna yanayin kawai Kalli Caps (kar a manta kashe shi daga baya).
lura: Lambobin Roman ba za su iya shiga cikin lissafin lissafin da aka yi a cikin Excel ba, saboda shirin a cikin wannan yanayin zai iya fahimtar haruffan Larabci kawai.
Saka alama
Ba kasafai ake amfani da wannan hanyar ba, musamman lokacin da saboda wasu dalilai madannai ba ya aiki ko kuma ba a haɗa su ba. Amma har yanzu yana nan, don haka za mu kwatanta shi.
- Muna tsaye a cikin tantanin halitta wanda muke son saka lamba a ciki. Sannan a cikin tab "Saka" danna kan icon "alama" (rukunin kayan aiki "alamomi").
- Wani taga zai buɗe wanda shafin zai fara aiki ta atomatik. "alamomi". Anan za mu iya saita font ɗin da muka zaɓa (danna zaɓi na yanzu kuma zaɓi daga jerin da aka tsara).
- Don siga "Kit" a cikin hanyar guda, mun zaɓi zaɓi - "Latin asali".
- Yanzu kawai danna alamar da ake so a filin da ke ƙasa, sannan danna "Saka" (ko kawai danna sau biyu akan shi). Alamar zata bayyana a cikin tantanin halitta da aka zaɓa. Lokacin da shigarwar ya cika, rufe taga ta latsa maɓallin da ya dace.
Amfani da aikin
Excel yana da aiki na musamman don lambobin Roman. Ƙwararrun masu amfani za su iya buga shi kai tsaye a cikin mashaya dabara. Tsarinsa yayi kama da haka:
= ROMAN (lamba, [form])
Ana buƙatar siga kawai "Lambar" – Anan muna buga lambar larabci, wanda ke buƙatar canza shi zuwa Roman. Hakanan, maimakon ƙayyadaddun ƙima, ana iya ƙayyadaddun nuni ga tantanin halitta.
Hujjar "form" na zaɓi (yana ba ka damar ƙayyade nau'in lamba a cikin bayanin Roman).
Koyaya, ya fi saba da sauƙi ga yawancin masu amfani don amfani Mayukan Ayyuka.
- Mun tashi a cikin tantanin halitta da ake so kuma danna gunkin sakawa "Fx" zuwa hagu na mashayin dabara.
- Ta zabar rukuni "Cikakken jerin haruffa" nemo kirtani "ROMAN", yi alama, sannan danna OK.
- Taga don cika gardamar aiki zai bayyana akan allon. A cikin filin "Lambar" shigar da lamba ta Larabci ko nuna hanyar haɗi zuwa tantanin halitta da ke ɗauke da shi (muna rubuta shi da hannu ko kuma kawai danna abin da ake so a cikin tebur da kansa). Hujja ta biyu ba ta cika cika ba, don haka kawai danna OK.
- Sakamakon a cikin nau'i na lambar Roman zai bayyana a cikin tantanin halitta da aka zaɓa, kuma shigarwar da ta dace kuma za ta kasance a cikin ma'auni.
Amfanin kwarai
Godiya ga aikin "ROMAN" Kuna iya canza sel da yawa lokaci guda, don kada kuyi aikin da hannu ga kowannensu.
A ce muna da ginshiƙi mai lambobin larabci.
Don samun shafi tare da Romawa, yi matakai masu zuwa:
- Amfani da aikin "ROMAN" yi canjin tantanin halitta na farko a ko'ina, amma zai fi dacewa a jere ɗaya.
- Muna shawagi a kan ƙananan kusurwar dama na tantanin halitta tare da sakamakon, kuma da zaran baƙar fata (cika alama) ya bayyana, tare da maɓallin linzamin kwamfuta na hagu, ja shi zuwa layin karshe wanda ya ƙunshi bayanai.
- Da zaran mun saki maɓallin linzamin kwamfuta, ainihin lambobi a cikin sabon shafi suna canzawa ta atomatik zuwa Roman.
Kammalawa
Don haka, a cikin Excel akwai hanyoyi daban-daban da za ku iya rubuta ko liƙa lambobin Roman cikin sel daftarin aiki. Zaɓin ɗayan ko wata hanya ya dogara da ilimi da ƙwarewar mai amfani, da kuma adadin bayanan da ake sarrafawa.