Ukushintsha ikhefana nesikhathi ku-Microsoft Excel

Kuyaziwa ukuthi enguqulweni yesiRussia ye-Excel, ikhefana lisetshenziswa njengesihlukanisi sedesimali, kuyilapho kuhlobo lwesiNgisi kusetshenziswa inkathi. Lokhu kungenxa yokuba khona kwamazinga ahlukahlukene kulo mkhakha. Ngaphezu kwalokho, emazweni akhuluma isiNgisi kuwumkhuba ukusebenzisa ukhefana njengomahlukanisi, kuthi kithi isikhathi esithile. Futhi, lokhu kubangela inkinga lapho umsebenzisi evula ifayili elenziwe kuhlelo ngohlelo lwasekhaya elehlukile. Kufika ephuzwini lokuthi i-Excel ayicabangi ngisho nangamafomula, ngoba ibona izimpawu ngokungalungile. Kulokhu, kufanele ushintshe ukwenziwa kwendawo kohlelo kuzilungiselelo, noma ufake izinhlamvu endaweni yombhalo. Ake sibheke ukuthi singayishintsha kanjani i-comma iphuzu kulolu hlelo lokusebenza.

Inqubo yokufaka esikhundleni

Ngaphambi kokuqhubeka nokufaka okunye, okokuqala kudingeka uqonde ngokwakho ukuthi wenzelani. Yinto eyodwa uma wenza le nqubo ngoba nje ubona umbono njengesihlukanisi futhi ungahleleli ukusebenzisa lezi zinombolo ekubaleni. Kuyinto futhi uma ungadinga ukushintsha isibonakaliso ngqo ukuze kubalwe, ngoba ngokuzayo lo mbhalo uzobe usucutshungulwa kuhlobo lwesiNgisi i-Excel.

Indlela yoku-1: Thola Ithuluzi Eliphindwayo

Indlela elula yokuguqula ikhefana iphuzu ukusebenzisa ithuluzi Thola bese Ufaka esikhundleni. Kepha, kufanele kuphawulwe lapho ukuthi le ndlela ayifanele ukubalwa, ngoba okuqukethwe ngamaseli kuzoshintshwa kufomethi yombhalo.

1. Sikhetha indawo eshidini lapho ofuna ukuguqula khona ukhefana lube ngamaphoyinti. Qhafaza kahle igundane. Kumenyu yokuqukethwe eqala, phawula into "Ifomethi yeseli ...". Labo basebenzisi abathanda ukusebenzisa ezinye izindlela ngokusebenzisa "izinkinobho ezishisayo", ngemuva kokugqamisa, bangathayipha inhlanganisela yezinkinobho I-Ctrl + 1.



2. Iwindi lokufometha liqalisiwe. Hambisa kuthebhu "Inombolo". Eqenjini lepharamitha "Amafomethi ezinombolo" hambisa ukukhetha esikhundleni "Umbhalo". Ukuze ugcine izinguquko, chofoza inkinobho "Kulungile". Ifomethi yedatha ebangeni elikhethiwe izoguqulwa ibe umbhalo.



3. Futhi, khetha ibanga eliqondiwe. Lokhu kungumqondo obalulekile, ngoba ngaphandle kokuhlukaniswa kokuzimela, izinguquko zizokwenziwa kuyo yonke indawo eshidi, futhi lokhu kudingekile njalo. Ngemuva kokuthi indawo ikhethiwe, dlulela kuthebhu "Ikhaya". Chofoza inkinobho Thola nokugqamisaelibekwe endaweni yethuluzi "Ukuhlela" ekhasethini. Bese kuvula imenyu encane, lapho kufanele ukhethe khona "Faka esikhundleni ...".



4. Ngemuva kwalokho, ithuluzi liyaqala Thola bese Ufaka esikhundleni kuthebhu Faka esikhundleni. Ensimini Thola setha isibonakaliso ",", nasensimini "Faka esikhundleni no" - ".". Chofoza inkinobho Esikhundleni Sonke.



5. Iwindows yolwazi livula lapho kunikezwa khona umbiko ngoguquko oluphelile. Chofoza inkinobho "Kulungile".

Uhlelo lolu lenza inqubo yokuguqula ama-coma abe ngamaphuzu ebangeni elikhethiwe. Kulokhu, le nkinga ingabhekwa njengexazululekile. Kepha kufanele kukhunjulwe ukuthi idatha efakwe ngale ndlela izoba nefomethi yombhalo, futhi, ngakho-ke, angeke isetshenziswe ekubalweni.

Isifundo: Ukufakwa Kwenhlamvu ku-Excel

Indlela 2: ukusebenzisa umsebenzi

Indlela yesibili ifaka ukusetshenziswa kwe-opharetha SUBSTITUTE. Ukuze siqale, sisebenzisa lo msebenzi, siguqula imininingwane ngokwehlukile, bese siyikopishela endaweni yasekuqaleni.

1. Khetha iseli elingenalutho elibhekene neseli lokuqala lobubanzi bedatha lapho amakhoma kufanele aguqulwe abe ngamaphoyinti. Chofoza isithonjana. "Faka umsebenzi"ibekwe kwesokunxele sebha lefomula.



2. Ngemuva kwalezi zenzo, kuzokwethulwa i-Function Wizard. Sibheke esigabeni "Hlola" noma "Uhlu oluphelele lwe-alfabhethi" igama SUBSTITUTE. Khetha bese uchofoza inkinobho. "Kulungile".



3. Iwindi lokuphikisana ngomsebenzi liyavula. Unezimpikiswano ezintathu ezidingekayo. "Umbhalo", "Umbhalo wakudala" futhi "Umbhalo omusha". Ensimini "Umbhalo" udinga ukucacisa ikheli leseli lapho idatha okufanele ishintshwe khona Ukuze wenze lokhu, setha ikhesa kule nkambu, bese uqhafaza eshidi esitokisini sokuqala sobubanzi obuhlukahlukene. Ngokushesha emva kwalokho, ikheli lizovela ewindini lokuphikisana. Ensimini "Umbhalo wakudala" setha umlingiswa olandelayo - ",". Ensimini "Umbhalo omusha" beka iphuzu - ".". Ngemuva kokuthi idatha ifakiwe, chofoza inkinobho "Kulungile".



4. Njengoba ubona, ukuguqulwa kwaphumelela iseli lokuqala. Ukusebenza okufanayo kungenziwa kuwo wonke amanye amaseli ebanga olufunayo. Yebo, uma lolu banga lincane. Kepha kuthiwani uma iqukethe amaseli amaningi? Ngempela, ukuguqulwa ngale ndlela, kulokhu, kuzothatha isikhathi esikhulu. Kepha, inqubo ingasheshiswa kakhulu ngokukopisha ifomula SUBSTITUTE usebenzisa umaki wokugcwalisa.

   Sibeka ikhesa onqenqemeni olungakwesokunxele lweseli lapho kusebenza khona. Umaka wokugcwalisa uvela njengesiphambano esincane. Bamba inkinobho yegundane kwesobunxele bese uhudula lesi siphambano esifanayo endaweni lapho ufuna ukuguqula khona ukhefana lube ngamaphoyinti.



5. Njengoba ukwazi ukubona, konke okuqukethwe kwebanga eliqondisiwe kwaguqulwa kube yidatha enezikhathi esikhundleni sokudla. Manje udinga ukukopisha umphumela bese unamathisele endaweni yomthombo. Khetha amaseli ngefomula. Ukuba kuthebhu "Ikhaya"chofoza inkinobho kubambo Kopishaetholakala eqenjini lamathuluzi Ibhodi yokunamathisela. Kungenziwa lula, okungukuthi, ngemuva kokukhetha ibanga, thayipha inhlanganisela yezinkinobho kukhibhodi I-Ctrl + 1.



6. Khetha ibanga lomthombo. Sichofoza kukhetho ngenkinobho yegundane elifanele. Imenyu yokuqukethwe iyavela. Kuyo, chofoza entweni "Amanani"etholakala eqenjini Faka Izinketho. Le nto ikhonjiswa izinombolo. "123".



7. Ngemuva kwalezi zinyathelo, amanani azofakwa ebangeni elifanele. Kulokhu, amakhoma azoguqulwa abe ngamaphuzu. Ukususa indawo esingasayidingi, egcwele amafomula, khetha bese uchofoza ngakwesokudla. Kumenyu evelayo, khetha Sula okuqukethwe.

Ukuguqulwa kwedatha ekushintsheni ama-commas kumaphoyinti kuqediwe, futhi zonke izinto ezingadingekile ziyasuswa.

Isifundo: Umsebenzi Wizard e-Excel

Indlela 3: Sebenzisa iMacro

Indlela elandelayo yokuguqula ama-comma abe ngamaphuzu ngokusebenzisa ama-macros. Kodwa, into ukuthi ama-macros ku-Excel akhutshaziwe ngokuzenzakalela.

Okokuqala, vumela ama-macros bese wenza ukuthi ithebhu isebenze "Unjiniyela"uma kuhlelo lwakho asasebenza. Ngemuva kwalokho, udinga ukwenza lezi zinto ezilandelayo:

1. Hambisa kuthebhu "Unjiniyela" bese uchofoza inkinobho "Okubonakalayo okuyisisekelo"elibekwe endaweni yethuluzi "Ikhodi" ekhasethini.



2. Umhleli we-macro uyavuleka. Faka ikhodi elandelayo kuyo:

   I-Sub Comma_Transfform_Macro_Macro ()
Ukukhetha.Replace What: = ",", Replacement: = "."
Qeda sub

   Siphetha ukuhlela sisebenzisa indlela ejwayelekile ngokuchofoza inkinobho esondele ekhoneni eliphezulu kwesokudla.



3. Okulandelayo, khetha ibanga lapho ukuguqulwa kufanele kwenziwe khona. Chofoza inkinobho IMacrosetholakala wonke eqenjini elilodwa lamathuluzi "Ikhodi".



4. Iwindows livula ngohlu lwama-macros atholakala encwadini. Khetha eyodwa esanda kwenziwa ngomhleli. Ngemuva kokuthi siqhakambise umugqa ngegama lawo, chofoza inkinobho Gijima.

Ukuguqulwa kuyaqhubeka. Ama-Commas azoguqulwa abe amachashazi.

Isifundo: Ungayakha kanjani iMacro ku-Excel

Indlela 4: Izilungiselelo ze-Excel

Indlela elandelayo iyodwa kuphela okungenhla, lapho kuguqulwa khona amachashazi abe amachashazi, inkulumo izobonwa ngohlelo njengenombolo, hhayi njengombhalo. Ukwenza lokhu, kuzodingeka siguqule isihlukanisi sohlelo kuzilungiselelo ezine-semicolon ukuya endaweni.

1. Ukuba kuthebhu Ifayela, chofoza igama le-block "Izinketho".



2. Ewindini lokukhethwa kukho, yiya esigatshaneni "Kuthuthukile". Sifuna amabhlokhi wezilungiselelo Hlela Izinketho. Ungahloli ibhokisi eliseduze nenani "Sebenzisa abahlukanisi bohlelo". Ngemuva kwalokho "Ukwehlukaniswa kwezingxenye eziphelele nezinhle kakhulu" yenza esikhundleni se "," kuvuliwe ".". Ukufaka imingcele, chofoza inkinobho "Kulungile".

Ngemuva kwalezi zinyathelo ezingenhla, amakhoma ayesetshenziswa njengabahlukanisi bezingxenyana azoguqulwa abe ngamaphuzu. Kepha, okubaluleke kakhulu, izinkulumo ezisetshenziswe kuzo zizohlala zizinombolo, futhi ngeke ziguqulwe zibe ngumbhalo.

Kunezindlela eziningi zokuguqula ikheyi ibe yizikhathi kumadokhumenti e-Excel. Iningi lalezi zinketho lifaka phakathi ukuguqula ifomethi yedatha kusuka kunombolo kuya kumbhalo. Lokhu kuholela eqinisweni lokuthi uhlelo alukwazi ukusebenzisa lezi zinkulumo ekubalweni. Kepha futhi kunendlela yokuguqula ama-commas abe ngamachashazi ngenkathi kulondolozwa ukufomatha kwasekuqaleni. Ukuze wenze lokhu, kuzodingeka ukuthi ushintshe izilungiselelo zohlelo uqobo.