Inani emagameni ku-Excel. Ungabhala kanjani inani lamagama ku-Excel

Microsoft Excel tools are most commonly used to work with numbers. Sometimes it is necessary that a number, such as a sum of money, be written in words. This becomes especially important when drawing up financial documents. Writing each number in words manually is inconvenient. In addition, numerals in are one of the most difficult topics, and not everyone knows the rules for writing them. Illiteracy in documents harms the reputation of the company, so you should use the help of Excel services. Let’s find out how to add the “Amount in words” function to the program and use it correctly.

Nika amandla isengezo se-NUM2TEXT kumenyu ye-Excel

Ngaphambi kokudala amaseli anezibalo ngamagama, udinga ukulanda isengezo se-Microsoft Excel. Azikho izengezo kuwebhusayithi esemthethweni yonjiniyela, kodwa zingalandwa kwamanye amakhasi. Kubalulekile ukuhlola amafayela alandwe kukhompyutha usebenzisa uhlelo lwe-antivirus, ngaphandle kwalokho kunengozi yokuthelela uhlelo ngegciwane. Futhi naka imvume yefayela. Isixazululo esilungile sithi XLA. Uma isengezo sesivele silandiwe, sibeke kufolda lapho kuzoba lula ukutholakala khona. Lokhu kuzoba usizo uma uxhuma. Okulandelayo, sizohlaziya ukufakwa kwesinyathelo ngesinyathelo sokungeza:

1. Udinga ukuvula ithebhu ethi “Ifayela” kudokhumenti ye-Excel bese ukhetha ingxenye ethi “Izinketho”. Ngokuvamile kutholakala phansi ohlwini lwezigaba.

2. Iwindi lezinketho lizovuleka ngemenyu ngakwesokunxele. Khetha ingxenye ethi "Izengezo". Uma ngabe usubheka ngakwesokudla kwesikrini, ungabona ukuthi ezinye zazo zifakwe ngaphambili, kodwa azifaneleki ukubhalwa lula kwenani ngamagama.

Ngezansi kunesigatshana esithi “Ukuphatha” esinenkinobho ethi “Hamba”. Sichofoza le nkinobho.

3. Iwindi elinezengezo ezitholakalayo lizovela esikrinini. Ungavumela ezinye zazo uma kudingeka, kodwa umgomo kuleli cala yinkinobho ethi Phequlula.

4. Sithola ifayela elinesengezo ngewindi lokuphequlula. Chofoza kuyo ukuze ukhethe bese uchofoza OK.

5. Into ethi “Num2Text” izovela ohlwini lwezengezo. Kufanele kube nophawu eceleni kwalo. Uma ingekho efasiteleni, udinga ukukhetha lesi sengezo ngesandla bese uchofoza "KULUNGILE".

Ukuxhumeka kwesengezo esithi “Inani ngamagama” kuqediwe, manje ungasisebenzisa.

Izenzo ngesengezo ngemva kokuxhumeka

Isengezo esithi “Inani emagameni” siyisengezo kokuthi “Umphathi Womsebenzi” Excel. Wengeza ifomula eyodwa entsha ohlwini, ongaguqula ngayo noma iyiphi inombolo ibe amagama. Masikhumbule ukuthi singasebenza kanjani “Nesiphathi Sesici” futhi sibheke isengezo esisebenzayo.

1. Masenze itafula elinezinombolo ezidinga ukubhalwa ngamagama. Uma isivele ikhona, udinga kuphela ukuvula idokhumenti lapho ihlanganiswe khona.
2. Okulandelayo, chofoza iseli elingenalutho lapho inani kufanele livele ngamagama, bese uvula "Umphathi Womsebenzi".

Kubalulekile! Ungafika kulesi sigaba se-Excel ngezindlela eziningi: ngesithonjana esiseduze komugqa wokusebenza noma ngethebhu Amafomula (inkinobho ethi Faka Umsebenzi).

3. Khetha isigaba “Uhlu olugcwele lwama-alfabhethi”. Kuzodingeka uskrolele phansi kuhlamvu “C” ngoba isici asingeni kunoma yiziphi izigaba ezincane. Okulandelayo, udinga ukuchofoza egameni lomsebenzi othi "Amount_in words" bese uchofoza okuthi "KULUNGILE".

4. Khetha iseli elinenombolo okufanele inani layo lombhalo livele kuseli elingenalutho. Uhlaka olugqwayizayo kufanele luvele ngakulo, futhi igama elivundlile neliqondile lizowela kufomula. Cindezela inkinobho ethi "KULUNGILE".

5. Ngenxa yalokho, inani lamagama liyavela kuseli elikhethwe ekuqaleni. Kubukeka kanjena:

6. Manje usungakwazi ukugcwalisa ithebula lonke ngaphandle kokwenza imisebenzi efanayo ngomugqa ngamunye. Uma uchofoza kunoma iyiphi iseli, kuzovela uhlaka olumnyama nxazonke zalo (lumhlophe uma iseli lisethebula elinemingcele), futhi kukhona umaka oyisikwele omnyama ekhoneni elingezansi kwesokudla. Khetha iseli lapho umsebenzi othi “Sum_in words” utholakala khona, bamba lesi sikwele bese usihudulela ekugcineni kwetafula.

7. Ifomula izothuthela kuwo wonke amaseli angezansi athwetshulwe ukukhetha. Kunokushintshashintsha kwamaseli, ngenxa yokuthi inani elifanele lamagama livela kumugqa ngamunye. Ithebula lithatha ngendlela elandelayo:

Ukufakwa mathupha komsebenzi kumaseli

Esikhundleni sokudlula ezinyathelweni zokuvula “Umphathi Womsebenzi” bese ubheka umsebenzi owufunayo, ungafaka ifomula ngqo kuseli. Ake sithole ukuthi ungagcwalisa kanjani itafula ngaphandle kokusebenzisa ibha yamathuluzi.

1. Okokuqala udinga ukukhetha iseli elingenalutho lapho ifomula izobhalwa khona. Chofoza kabili kuyo - inkambu yokufaka idatha kusuka kukhibhodi izovela ngaphakathi.
2. Masibhale ifomula elandelayo endaweni engenalutho: =Inani_ngamagama().

Isincomo! Ngemva kokusetha uphawu olulinganayo, uhlelo luzonikeza amacebo ngendlela yamafomula. Ukufaka okuningi ngomugqa ngamunye, iseluleko sizoba nembe kakhulu. Kulula kakhulu ukuthola umsebenzi oyifunayo kulolu hlu bese uchofoza kabili kuwo.

3. Kubakaki, udinga ukucacisa iseli, okuqukethwe okuzobhalwa ngamagama.

Nakani! Kungenzeka ukuthi ubhale ngamagama hhayi kuphela okuqukethwe kwezinombolo zeseli eyodwa, kodwa futhi umphumela wokusebenza kwezibalo ngezinombolo ezivela kumaseli amaningana. Isibonelo, uma ukhetha iseli elilodwa, faka uphawu “+” ngemva kokuqokwa kwalo futhi ubonise igama lesibili – elinye iseli, umphumela uzoba isamba sezinombolo ezimbili ezibhalwe ngamagama.

4. Cindezela inkinobho ethi "Enter". Amaseli azobonisa inombolo noma umphumela wesenzo, ovezwe ngamagama.

Kungenzeka ukuthi ubhale inombolo ngamagama ngaphandle kokwenza ithebula - okudingayo nje ifomula kanye nembewu noma isenzo. Kuyadingeka futhi ukubhala ifomula kuseli elingenalutho, kodwa kubakaki, esikhundleni sezimpawu ezivundlile nezime mpo, bhala inombolo noma isisho. Vala amabakaki bese ucindezela u-“Enter” – izinombolo ezidingekayo zivela kuseli.

Isiphetho

Ukuze ubhale izinombolo ngamagama, udinga ukulanda isengezo se-Microsoft Excel bese usixhuma ohlelweni bese usenza sisebenze, "Umphathi Womsebenzi" udlala indima ebalulekile ezenzweni ezengeziwe. Umsebenzi ungasetshenziswa kokubili kokuqukethwe amaseli nasezinombolo ezingaphandle kwamathebula. Ngokubeka isisho sezibalo kumsebenzi, ungathola umphumela waso kunkulumo yomlomo.