Ukufaka esikhundleni se-comma ngephuzu ku-Microsoft Excel

Kuyaziwa ukuthi kuyi-Russian version ye-Excel, i-comma isetshenzisiwe njengehlukanisi yedesimali, kuyilapho inguqulo yesiNgisi iphuzu lisetshenziswa. Lokhu kungenxa yokuba khona kwamazinga ahlukahlukene kule ndawo. Ngaphezu kwalokho, emazweni akhuluma isiNgisi, kuwumkhuba wokusebenzisa i-comma njengomhlukanisi we-discharge, nasezweni lethu - isikhathi. Futhi, lokhu kubangela inkinga lapho umsebenzisi evula ifayela elenziwe ohlelweni lendawo ehlukile. Kufika eqinisweni lokuthi i-Excel ayicabangi ngisho namafomula, ngoba ayiqondi kahle izimpawu. Kulesi simo, udinga ukuguqula ukuhlelwa kohlelo kwamasethingi, noma ukushintsha izinhlamvu kulo mbhalo. Ake sithole ukuthi singashintsha kanjani i-comma kuze kube iphuzu kulolu hlelo lokusebenza.

Inqubo yokufaka esikhundleni

Ngaphambi kokuba uqale ukuthatha indawo, udinga ukuziqonda kuqala ukuthi yini oyithengisayo. Kuyinto eyodwa uma uqhuba le nqubo nje ngoba ubona ngokucacile iphuzu njengehlukana futhi ungahle usebenzise lezi zinombolo kubalo. Kuyinto enye into uma udinga ukushintsha isibonakaliso sokubala, njengoba esikhathini esizayo idokhumenti izocutshungulwa ngesiNgisi inguqulo ye-Excel.

Indlela 1: Thola futhi Ubeke Ithuluzi

Indlela elula yokwenza ushintsho lwe-comma-to-dot ukusebenzisa ithuluzi. "Thola futhi ushintshe". Kodwa, masinyane kufanele kuqashelwe ukuthi le ndlela ayifanele ukubalwa, ngoba okuqukethwe kwamaseli kuzoguqulwa ibe yifomethi yombhalo.

1. Yenza okukhethiwe kwendawo kushidi, lapho udinga ukuguqula ama-commas ngamaphuzu. Yenza ngokuchofoza ngakwesokudla. Emenyu yemenyu eqalisiwe, khetha into "Fometha amaseli ...". Labo abasebenzisi abakhetha ukusebenzisa okunye okukhethwa kukho ngokusetshenziswa "okhiye abashisayo", emva kokukhetha, bangakwazi ukuthayipha inhlanganisela yokhiye Ctrl + 1.



2. Iwindi yokufometha iqaliswa. Hambisa kuthebhu "Inombolo". Eqenjini lemingcele "Amafomu Amanani" hambisa ukukhetha ukuma "Umbhalo". Ukuze ulondoloze izinguquko ezenziwe, chofoza inkinobho. "Kulungile". Ifomethi yedatha ebangeni elikhethiwe izoguqulwa ibe umbhalo.



3. Futhi, khetha uhla lwamathekisthi. Lokhu kubaluleke kakhulu, ngoba ngaphandle kokhetho olukhethiwe, ukuguqulwa kuyokwenziwa kuyo yonke indawo yeshidi, futhi lokhu akudingeki ngaso sonke isikhathi. Ngemuva kokuthi indawo ikhethiwe, hamba kuthebhu "Ikhaya". Chofoza inkinobho "Thola futhi uqokomise"esitholakala kwibhulogi yamathuluzi Ukuhlela kwi-tape. Khona-ke imenyu encane ivula lapho okufanele ukhethe khona "Faka esikhundleni ...".



4. Emva kwalokho, ithuluzi liqala. "Thola futhi ushintshe" kuthebhu "Faka esikhundleni". Ensimini "Thola" setha uphawu ","futhi ensimini "Faka esikhundleni" - ".". Chofoza inkinobho "Faka konke".



5. Iwindwangu yolwazi ivuleka lapho umbiko wezinguquko ezigcwalisiwe kuhanjiswa. Chofoza inkinobho. "Kulungile".

Lolu hlelo lwenza ushintsho lwamakhompiyutha kumaphuzu ebangeni elikhethiwe. Lo msebenzi ungabhekwa njengokuxazululwa. Kodwa kufanele kukhunjulwe ukuthi idatha edluliselwe ngale ndlela izoba nefomethi yombhalo futhi, ngakho-ke, ayikwazi ukusetshenziswa emabalazweni.

Isifundo: I-Excel Character Replacement

Indlela 2: sebenzisa umsebenzi

Indlela yesibili ihilela ukusebenza komqhubi THOLA. Okokuqala, usebenzisa lolu msebenzi, sizoguqula idatha ebangeni elihlukile, bese siyikopisha endaweni yokuqala.

1. Khetha iseli elingenalutho elibhekene neseli yokuqala yedatha lokwaziswa, lapho ama-commas kufanele aguqulwe abe amaphuzu. Chofoza kusithonjana "Faka umsebenzi"kufakwe ngakwesokunxele kwe-bar yefomula.



2. Emva kwalezi zenzo, i-wizard yomsebenzi izosungulwa. Sesha kusigaba "Hlola" noma "Uhlu oluphelele lwe-alfabhethi" igama "THOLA". Khetha bese uchofoza inkinobho. "Kulungile".



3. Iwindi lempikiswano yokusebenza ivula. Kunemibono emithathu edingekayo. "Umbhalo", "Umbhalo omdala" futhi "Umbhalo omusha". Ensimini "Umbhalo" Udinga ukucacisa ikheli leseli lapho idatha izobe khona khona. Ukwenza lokhu, setha isikhombisi kule nsimu, bese uchofoza kushidi esitokisini sokuqala kohlu oluguquguqukayo. Masinyane emva kwalokhu, ikheli lizovela efasiteleni lokuphikisana. Ensimini "Umbhalo omdala" setha uhlamvu olulandelayo - ",". Ensimini "Umbhalo omusha" faka iphuzu - ".". Ngemuva kwedatha efakiwe, chofoza inkinobho "Kulungile".



4. Njengoba ubona, ukuguqulwa kweseli lokuqala kwaphumelela. Ukusebenza okufanayo kungenziwa kuwo wonke amanye amaseli ebanga elifunayo. Yebo, uma lolu hlu luyingcosana. Kodwa kuthiwani uma iqukethe amaseli amaningi? Phela, ukuguqulwa ngale ndlela, kulokhu, kuzothatha isikhathi esiningi. Kodwa, inqubo ingashesha kakhulu ngokukopisha ifomula THOLA usebenzisa uphawu lokugcwalisa.

   Beka isikhombisi ngakwesokunene kwesokunxele kweseli eline-function. Uphawu lokugcwalisa luvela ngesimo se-cross encane. Cisha inkinobho yegundane lesokunxele bese uhudulela lesi sithinteli esifanayo nendawo ofuna ukuguqula ama-commas ngamaphuzu.



5. Njengoba ubona, konke okuqukethwe ebangeni lesikhangiso kwaguqulwa kudatha ngamachashazi esikhundleni sama-commas. Manje udinga ukukopisha umphumela futhi unamathisele endaweni yomthombo. Khetha amaseli anefomula. Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza inkinobho ku-ribbon "Kopisha"esithombeni lesithuluzi "Ibhodi lokunamathisela". Ungenza kube lula, okungukuthi ngemuva kokukhetha ibanga ukuthayipha inhlanganisela yekhibhodi ekhibhodi Ctrl + 1.



6. Khetha ububanzi bokuqala. Chofoza ekukhethweni ngenkinobho yegundane efanele. Imenyu yomongo ivela. Kulo, chofoza into "Amanani"esithombeni "Izinketho zokufaka". Le nto iboniswa izinombolo. "123".



7. Emva kwalezi zenzo, amanani azofakwa ebangeni elifanele. Kulokhu, ama-commas azoguqulwa abe amaphuzu. Ukuze ususe isifunda esingasadingeki kithi, sigcwaliswe amafomula, ukhethe bese uchofoza inkinobho yesokudla yegundane. Emenyu evelayo, khetha into "Sula okuqukethwe".

Ukuguqulwa kwedatha ekushintsheni kwamakhompi kumaphoyinti kuqediwe, futhi zonke izakhi ezingadingekile zisusiwe.

Isifundo: I-Excel Function Wizard

Indlela 3: Sebenzisa i-Macro

Indlela elandelayo yokushintsha ama-commas ngamaphuzu ahlobene nokusetshenziswa kwama-macros. Kodwa, into ukuthi ngokuzenzakalelayo, ama-macros ku-Excel ayakhutshaziwe.

Okokuqala, kufanele unike amandla ama-macros, futhi usebenze ithebhu "Unjiniyela", uma engakasebenzi kuhlelo lwakho. Emva kwalokho udinga ukwenza okulandelayo:

1. Hambisa kuthebhu "Unjiniyela" bese uchofoza inkinobho "Visual Basic"esitholakala kwibhulogi yamathuluzi "Ikhodi" kwi-tape.



2. Umhleli we-macro uvula. Sifaka ikhodi elandelayo kuyo:

   I-Macro_transformation_completion_point_point ()
Ukukhethwa.Shintsha lokho: = ",", esikhundleni: = "."
Qedela ngaphansi

   Qedela umsebenzi we-editor ngendlela ejwayelekile ngokuchofoza inkinobho yokuvala ekhoneni eliphezulu elingakwesokudla.



3. Okulandelayo, khetha ibanga okufanele uguqule ngalo. Chofoza inkinobho Macrosokuyiqembu elilodwa lamathuluzi "Ikhodi".



4. Ifasitela ivula uhlu lwamacros olutholakala encwadini. Khetha lowo osanda kudalwa ngokusebenzisa umhleli. Emva kokukhetha umugqa ngegama layo, chofoza inkinobho Qalisa.

Ukuguqulwa kuyaqhubeka. Ama-Commas azoguqulwa abe amaphuzu.

Isifundo: Indlela yokudala i-macro ku-Excel

Indlela 4: Izilungiselelo ze-Excel

Indlela elandelayo yiyona yodwa phakathi kwalapha ngenhla, lapho, lapho kuguqulwa ama-commas abe amaphuzu, le nkulumo izobonwa nguhlelo njengenombolo, hhayi njengombhalo. Ukwenza lokhu, kuzodingeka sishintshe umhlukanisi wesistimu kuzilungiselelo nge-comma isikhathi.

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



2. Ewindini lemingcele sithuthela esigatshaneni "Okuthuthukisiwe". Sifuna izilungiselelo ze-block "Izinketho zokuhlela". Susa ibhokisi lokuhlola eduze kwexabiso. "Sebenzisa ama-delimiters wesistimu". Khona-ke esigabeni "Umhlukanisi wengxenye yonke kanye nengxenye" shintsha "," kuqhubeke ".". Ukufaka amapharamitha ngesenzo chofoza inkinobho. "Kulungile".

Ngemuva kwezinyathelo ezingenhla, amakhamera asetshenziswe njengabahlukanisi bezingxenyana azoguqulwa zibe yizikhathi. Kodwa, okubaluleke kakhulu, izinkulumo ezisetshenzisiwe kuzohlala zizinombolo, futhi ngeke ziguqulwe zibe umbhalo.

Kunezindlela eziningi zokuguqula ama-commas kumaphoyinti emadokhumenti e-Excel. Iningi lalezi zinketho zihilela ukushintsha ifomethi yedatha kusuka kunombolo ukuya kumbhalo. Lokhu kuholela eqinisweni lokuthi lolu hlelo alukwazi ukusebenzisa lezi zinkulumo ekubaleni. Kodwa kukhona futhi indlela yokuguqula ama-commas amaphuzu, ukulondoloza ukufometha kwangempela. Ukuze wenze lokhu, kuzodingeka ushintshe izilungiselelo zohlelo uqobo.