Adadin a cikin kalmomi a cikin Microsoft Excel

A lokacin da ya cika takardun kudi, ana buƙatar yin rajistar yawan ba kawai a yawan ba, har ma a cikin kalmomi. Hakika, yana buƙatar lokaci fiye da rubutaccen rubutu tare da lambobi. Idan ta wannan hanya kana buƙatar cika ɗaya, amma da yawa takardu, to, hasara na wucin gadi ya zama babbar. Bugu da kari, an rubuta adadin a cikin kalmomin ƙananan kurakurai na yau da kullum. Bari mu kwatanta hanyar yin lambobi a cikin kalmomi ta atomatik.

Yi amfani da ƙara-kan

A Excel babu kayan aiki wanda zai taimaka ta atomatik fassara lambobi zuwa kalmomi. Saboda haka, don magance matsala ta amfani da ƙari na musamman.

Ɗaya daga cikin mafi dacewa shi ne add-in NUM2TEXT. Yana ba ka damar canja lambobin a kan haruffa ta hanyar mai aiki.

1. Bude Excel kuma je zuwa shafin. "Fayil".



2. Matsar zuwa sashe "Zabuka".



3. A cikin matakan aiki na sigogi je zuwa sashe Ƙara-kan.



4. Bugu da ari, a cikin saitunan saiti "Gudanarwa" saita darajar Ƙara Add-ins. Muna danna maɓallin "Ku tafi ...".



5. Ƙarin ƙaramin ƙara-kunnawa Excel ya buɗe. Muna danna maɓallin "Review ...".



6. A cikin taga wanda yake buɗewa, muna neman fayil NUM2TEXT.xla da aka sauke da shi kuma an ajiye shi zuwa kwakwalwar kwamfutar. Zaɓi shi kuma danna maballin. "Ok".



7. Mun ga cewa wannan ɓangaren ya fito ne a cikin adabin da aka samo. Saka alamar kusa da abu NUM2TEXT kuma danna maballin "Ok".



8. Don duba yadda sabon aikin da aka shigar da shi, za mu rubuta adadin mai ƙira a cikin kowane sakon kyauta na takardar. Zaɓi kowane tantanin halitta. Danna kan gunkin "Saka aiki". Ana tsaye a gefen hagu na tsari.



9. Ya fara aikin mai aiki. A cikin cikakken jerin ayyukan haruffa muna neman rikodin. "Adadin". Ba a can ba, amma ya bayyana a nan bayan shigar da ƙara. Zaɓi wannan aikin. Muna danna maɓallin "Ok".



10. An buɗe shingen aikin aiki. Adadin. Ya ƙunshi kawai filin ɗaya. "Adadin". A nan za ku iya rubuta lambar da aka saba. An nuna shi a cikin tantanin da aka zaɓa a cikin tsarin yadda yawan kuɗin da aka rubuta a cikin kalmomi a rubles da kopecks.



Zaka iya shigar da adireshin kowane cell a filin. Ana yin wannan ta hanyar rikodin haɗin kai na wannan tantanin halitta, ko kuma ta latsa danna yayin da mai siginan kwamfuta ke cikin filin saitin. "Adadin". Muna danna maɓallin "Ok".



11. Bayan haka, kowace lambar da aka rubuta a cikin tantanin halitta da aka ƙayyade ta za a nuna shi a cikin nau'i na kudi a cikin kalmomi a wurin da aka saita tsarin aikin.

Za a iya yin amfani da aikin tare da hannu ba tare da kiran mai aiki ba. Yana da haɗi Adadin (adadin) ko Adadin (haɓaka tantancewa). Saboda haka, idan ka rubuta takarda a cikin tantanin halitta= Adadin (5)sannan bayan danna maballin Shigar a cikin wannan salula an rubuta "Cin rubles 00 kopecks".

Idan ka shigar da tsari a tantanin salula= Adadin (A2)to, a wannan yanayin, kowace lambar da aka shiga cikin cell A2 za a nuna a nan a cikin adadin kuɗi cikin kalmomi.

Kamar yadda kake gani, duk da gaskiyar cewa Excel ba shi da kayan aikin da aka gina don canza lambobi zuwa cikin tsarar kudi a cikin kalmomi, za'a iya samo wannan siffar ta sauƙaƙe ta hanyar shigar da ƙarin ƙaddara zuwa shirin.