Adadin cikin kalmomi a cikin Microsoft Excel

Lokacin cika takardun kudi daban-daban, ana buƙatar yawanci don yin rijistar adadin ba kawai a lamba ba, har ma a cikin kalmomi. Tabbas, wannan yana ɗaukar dogon lokaci fiye da haruffan al'ada tare da lambobi. Idan ta wannan hanyar wajibi ne a cika ba guda ɗaya ba, amma takardu masu yawa, to asarar ɗan lokaci ta zama babba. Bugu da kari, yana cikin rikodin adadin a kalmomin da yawancin kurakurai na nahawu ke faruwa. Bari mu gano yadda ake yin lambobi a cikin kalmomin da aka shigar ta atomatik.

Yin amfani da ƙari

A cikin Excel babu wani kayan aikin ginannun da zai taimaka wajan fassara lambobi ta atomatik zuwa kalmomi. Saboda haka, don magance wannan matsalar, ana amfani da ƙari na musamman.

Ofayan mafi dacewa shine addarin NUM2TEXT. Yana ba ku damar canza lambobi zuwa haruffa ta Mayen Aiki.

1. Bude shirin Excel kuma tafi zuwa shafin Fayiloli.



2. Mun matsa zuwa sashin "Zaɓuɓɓuka".



3. A cikin taga saiti mai aiki, je zuwa sashin "Karin abubuwa".



4. Na gaba, a cikin tsarin saiti "Gudanarwa" saita darajar Addara Add-ins. Latsa maballin "Ku tafi ...".



5. Wani karamin taga na Excel Add-ins yake budewa. Latsa maballin "Yi bita ...".



6. A cikin taga da ke buɗe, nemi fayil ɗin ƙarawa na NUM2TEXT.xla wanda aka riga aka saukar kuma an adana shi cikin diski mai kwakwalwa. Zaɓi shi kuma danna maballin. "Ok".



7. Mun ga cewa wannan kashi ya bayyana a cikin wadatar add-kan. Duba akwatin kusa da NUM2TEXT saika danna maballin. "Ok".



8. Don bincika yadda sabon shigar-da-wanda aka shigar yake aiki, zamu rubuta lambar sabani a kowace tantanin kyauta. Zaɓi wani tantanin halitta. Danna alamar "Saka aikin". An samo ta zuwa hagu na masarar dabara.



9. Mai maye aikin yana farawa. A cikin cikakkun jerin haruffan ayyuka muna neman rikodi "Sum_Account". Ba ta can a da, amma ta bayyana a nan bayan shigar da add-in. Muna haskaka wannan aikin. Latsa maballin "Ok".



10. Wurin muhawara na aiki zai buɗe Adadin Yawan Adanawa. Ya ƙunshi filin kawai. "Adadin". Kuna iya rubuta adadin da aka saba anan. Za a nuna shi a cikin tantanin da aka zaɓa a cikin tsarin da aka rubuta cikin kalmomi a cikin kuɗi a cikin rubles da kopecks.



Kuna iya shigar da adireshin kowane sel a fagen. Ana yin wannan ko dai ta hanyar rakodin rikodin wannan tantanin hannu, ko ta danna kan sa yayin da siginan kwamfuta ke cikin sigogi. "Adadin". Latsa maballin "Ok".



11. Bayan wannan, kowane lambar da aka rubuta a cikin tantanin da kuka ƙayyade za ku nuna shi a cikin monetary form a cikin kalmomi a wurin da aka saita tsarin aikin.

Hakanan zaka iya rikodin aiki da hannu ba tare da kiran jagoran maye ba. Yana da yanayin aiki Adadin Adadin (adadin) ko Adadin Adadin (cell_ daidaitawa). Saboda haka, idan ka rubuta folila a cikin tantanin halitta= Adadin Adadin (5)sannan bayan latsa maɓallin Shiga a cikin wannan kwayar an nuna rubutun "Five rubles 00 kopecks".

Idan ka shigar da dabara a kwayar halitta= Adadin Adadin (A2), to, a wannan yanayin, kowane lambar da aka shigar cikin tantanin halitta A2 za a nuna shi anan cikin tsabar kuɗi a cikin kalmomi.

Kamar yadda kake gani, duk da cewa Excel bata da kayan aiki da aka gina don sauya lambobi zuwa jimla a cikin kalmomi, wannan yanayin za'a iya samun saukin saukake ta hanyar shigar da abubuwanda suka dace a cikin shirin.