Ungayishintsha kanjani i-comma uye ephuzwini ku-Excel

Kuyaziwa ukuthi kwinguqulo yolimi lwesiRussia ye-Excel, i-comma isetshenziswa njengohlukanisi lwezimpawu zedesimali, kanti endaweni ekhuluma isiNgisi. Lokhu kungenxa yobukhona bezindinganiso ezahlukahlukene kule ndawo. Ngaphezu kwalokho, emazweni akhuluma isiNgisi, kwamukelwa njengohlukanisi lokukhipha ukusebenzisa ikhefana, futhi sinephuzu. Futhi, kubangela inkinga lapho umsebenzisi evula ifayili enziwe ohlelweni nolunye losendaweni. Kufika ephuzwini lokuthi i-Excel ayibheki nefomula, ngoba ngokungeyikho izimpawu. Kulokhu, udinga ukuguqula ukwenziwa kwalolu hlelo kuzilungiselelo, noma ukufaka izinhlamvu kudokhumenti. Ake sibheke ukuthi ungashintsha kanjani i-comma uye ephuzwini kulolu hlelo lokusebenza.

Inqubo yokubuyiselwa

Ngaphambi kokuqhubeka nokubuyisela esikhundleni, kuyadingeka ukuqonda okokuqala kwako konke okukukhiqizayo. Kuyinto eyodwa uma usebenzisa le nqubo ngoba ngokubona kangcono kangcono iphuzu njengehlukanisi futhi ungahleleli ukusebenzisa lezi zinombolo ekubaleni. Kunye into uma udinga ukushintsha isibonakaliso ngokunembile ukubalwa, ngoba ngokuzayo idokhumenti izocutshungulwa kwinguqulo yesiNgisi ye-Excel.

Indlela 1: "Thola bese ubeka esikhundleni sethuluzi"

Indlela elula yokwenza inguquko ye-semicolon ukusetshenziswa kwethuluzi elithi "Thola bese ubeka esikhundleni". Kepha, ngokushesha, kufanele kuqashelwe ukuthi le ndlela ayilungele ukubala, ngoba okuqukethwe amaseli kuzoguqulwa kube yifomethi yombhalo.

1. Siveza ukukhetha kwendawo eshidini lapho udinga ukuguqula amakhoma ngamaphuzu. Yenza inkinobho yegundane kwesokudla kwesokudla. Kumenyu yokuqalisa komongo, simaka into "ifomethi yeseli ...". Labo basebenzisi abathanda ukujabulela ezinye izinketho ngokusetshenziswa kwe- "Hot Keys", ngemuva kokukhetha inhlanganisela ye-Ctrl + 1.



2. Iwindi lokufometha liyasungulwa. Senza ukunyakaza kuthebhu "yenombolo". Eqenjini lamapharamitha "amafomethi wezinombolo", sihambisa ukukhetha esikhundleni se- "Umbhalo". Ukuze ulondoloze izinguquko ezenziwe, chofoza inkinobho ethi "Kulungile". Ifomethi yedatha ebangeni elikhethiwe izoguqulwa ibe umbhalo.



3. Uphinde wabele ibanga eliqondiwe. Lokhu kuyinto ebalulekile, ngoba ngaphandle kokwabiwa kwangaphambi kwesikhathi, ukuguqulwa kuzokhiqizwa kuyo yonke indawo yeshidi, futhi lokhu akudingeki ngaso sonke isikhathi. Ngemuva kokuthi le ndawo igqanyiswe, idluliselwe kuthebhu "Yasekhaya". Chofoza ku- "Thola bese ukhetha u-" Inkinobho, etholakala ku-Tower Limp "Editing" ebhokisini. Ngemuva kwalokho imenyu encane iyavuleka, lapho kufanele ukhethe khona "buyisela esikhundleni ...".



4. Ngemuva kwalokho, "Thola bese uthatha indawo" ithuluzi lethulwe kuthebhu Faka esikhundleni. Ensimini ethi "Thola", sabeka isibonakaliso ",", nasensimini "sithathe indawo" - ".". ".". ".". ".". ".". ".". ".". ".". ".". ".". ".". " Chofoza inkinobho ethi "Faka esikhundleni yonke".



5. Iwindi lemininingwane livula, elinikeza umbiko ngokuguqulwa kwenguquko. Sichofoza inkinobho ethi "Kulungile".

Uhlelo lwenza inqubo yenguquko yekhefana kuya kumaphoyinti ebangeni elizinikezele. Lo msebenzi ungaxazululwa. Kepha kufanele kukhunjulwe ukuthi idatha ithathelwe indawo ngale ndlela izoba nefomethi yombhalo, ngakho-ke ngeke ikwazi ukusetshenziselwa ukubala.

Isifundo: Ukufakwa esikhundleni kwezimpawu ku-Excel

Indlela 2: Umsebenzi wohlelo lokusebenza

Indlela yesibili isho ukusetshenziswa kwe-opharetha ukuze ungene esikhundleni. Ukuqala, ukusebenzisa lesi sici, siguqula idatha ebangeni elihlukile, bese siwakopisha endaweni yangempela.

1. Khetha iseli elingenalutho elibhekene neseli lokuqala lobubanzi bedatha lapho amakhoma kufanele aguqulwe khona ephuzwini. Chofoza isithonjana se- "Insert Function", ebekwe ngakwesobunxele sentambo yefomula.



2. Ngemuva kwalezi zenzo, kuzokwethulwa i-Master of imisebenzi. Sifuna esigabeni "sokuhlola" noma "uhlu olugcwele lwezinhlamvu" igama elithi "BANGCWELE". Siyigqabisisa bese uchofoza inkinobho ethi "Kulungile".



3. Ukuphikisana nomsebenzi kuyavuleka. Inezimpikiswano ezintathu eziphoqelekile "umbhalo", "umbhalo wakudala" kanye "nombhalo omusha". In the "Umbhalo", udinga ukucacisa ikheli leseli lapho idatha kufanele iguqulwe khona. Ukuze wenze lokhu, setha isikhombisi kulo mkhakha, bese uqhafaza igundane eshidini elisesilingweni sokuqala sebhendi. Masinyane nje ngemuva kwaleli kheli kuzovela efasiteleni lengxabano. Emkhakheni we- "Old Text", sabeka uphawu olulandelayo - ",". Ensimini ethi "Umbhalo omusha", sibeka iphuzu - ".". ".". Ngemuva kokuthi idatha yenziwe, chofoza inkinobho ethi "Kulungile".



4. Njengoba ubona, ngeseli lokuqala, ukuguqulwa kuyaphumelela. Ukusebenza okunjalo kungenziwa kuwo wonke amanye amaseli wobubanzi obufunayo. Yebo, uma leli banga lincane. Kepha yini okufanele yenze uma iqukethe amaseli ahlukahlukene? Ngemuva kwakho konke, ukuguqula ngendlela efanayo, kulokhu, kuzothatha isikhathi esikhulu sesikhathi. Kepha, inqubo ingasheshiswa kakhulu ngokukopisha ifomula ukufaka esikhundleni ngosizo lophawu lokugcwaliswa.

   Sisungula isikhombisi onqenqemeni olungaphansi lweseli, oluqukethe umsebenzi. Umaki wokugcwalisa ngendlela yesiphambano esincane avela. Cindezela inkinobho yegundane kwesobunxele bese uhudula lesi siphambano ngokufana nendawo okudingeka uguqule amakhoma ukuze uguqule.



5. Njengoba ubona, konke okuqukethwe yihlu lokuhlosiwe kuguqulwe kube yidatha ngamaphoyinti esikhundleni samakhoma. Manje udinga ukopisha umphumela bese ufaka endaweni yomthombo. Khetha amaseli ngefomula. Ngenkathi usethebhu yasekhaya, chofoza inkinobho ku-tepe "kokhophi", etholakala ku- "Buffer" ToolBu. Kungenziwa futhi kube lula, okungukuthi, ngemuva kokukhetha ububanzi, shayela inhlanganisela yokhiye kukhibhodi ye-CTRL + 1.



6. Khetha uhla lwangempela. Chofoza ukuze uqokomise inkinobho yegundane efanele. Imenyu yomongo iyavela. Kuyo, wenza ngokuchofoza entweni "yenani", etholakala ku- "Insert Parameters" Group. Le nto ikhonjiswa ngezinombolo "123".



7. Ngemuva kwalezi zenzo, amanani azofakwa ebangeni elifanele. Ngasikhathi sinye, amakhoma azoguqulwa abe ngamaphuzu. Ukususa indawo osuvele uyidinge, igcwele amafomula, qokomisana bese uqhafaza inkinobho yegundane elifanele. Kumenyu evela, khetha into ethi "Okuqukethwe okucacile".

Ukuguqula idatha ekushintsheni kwekhefana kuze kwenziwe iphuzu, futhi zonke izinto ezingadingekile ziyasuswa.

Isifundo: Imisebenzi yeWizard ku-Excel

Indlela 3: Ukusetshenziswa kweMacro

Indlela elandelayo yokuguqulwa kwama-comma kumaphoyinti ihlotshaniswa nokusetshenziswa kwama-macros. Kepha, leli cala ukuthi ngokuzenzakalelayo ama-macros e-efvelat akhutshaziwe.

Okokuqala, ama-macros kufanele anikwe amandla, futhi asebenze kabusha ithebhu yonjiniyela, uma bengasebenzi ohlelweni lwakho. Ngemuva kwalokho, udinga ukwenza izenzo ezilandelayo:

1. Sithuthela kuthebhu "kanjiniyela" bese sichofoza inkinobho ethi "Visual Basic", ebekwe ebhokisini le- "Code" ethepheni.



2. I-Macros iyavula. Sifeza i-Code Insert elandelayo:

   Sub Macro_transformation___v_v_chki ()

   Ukukhetha.RewPlace What: = ",", esikhundleni: = "."

   Qeda sub.

   Siqedela ukusebenza komhleli ngendlela ejwayelekile ngokuchofoza inkinobho yokuvala ekhoneni eliphezulu kwesokudla.



3. Okulandelayo, sabela ububanzi lapho uguquko kufanele lwenziwe khona. Chofoza inkinobho ethi "Macros", etholakala konke eqenjini elifanayo lamathuluzi ekhodi.



4. Iwindi livula ngohlu lwama-macros atholakala encwadini. Khetha eyodwa elisanda kudala isihleli. Ngemuva kokuthi ukhethe intambo ngegama layo, chofoza inkinobho ethi "Run".

Ukuguqulwa kwenziwa. Ama-Commas azoguqulwa abe ngamaphuzu.

Isifundo: Ungawakha kanjani i-macro ku-Excel

Indlela 4: Izilungiselelo Excel

Indlela elandelayo kuphela kuvela kulokho okungenhla, lapho uguqulwa khona lapho uguqulwa amakhomithi ngamaphuzu, le nkulumo izobonwa uhlelo njengenombolo, hhayi njengombhalo. Ukuze wenze lokhu, sizodinga ukushintsha i-System Support kuzilungiselelo zedesimali kuze kube sezingeni.

1. Ukuba sethebhu "File", chofoza igama le-block "paradeters".



2. Ewindini lepharamitha, sithuthela esigatshaneni esithuthukisiwe. Sikhiqiza ukusesha amasethingi we- "Hlela Parameter" Sisusa ibhokisi lokuhlola eduze kwenani elithi "Sebenzisa abahlukanisi bohlelo". Ngemuva kwalokho, engxenyeni ethi "Isahluko Sengxenye Ephelele Nokubizi Engxenyeni" Siveza Ukubuyiselwa Nge "," ku ".". Ukufaka amapharamitha, chofoza inkinobho ethi "Kulungile".

Ngemuva kwalokhu okungenhla, ama-commas, asetshenziswa njengabahlukanisi bezingxenyana, kuzoguqulwa kumaphoyinti. Kepha, into esemqoka, izinkulumo lapho zisetshenziswa kuzo zizohlala zinezinombolo, futhi ngeke ziguqulwe zibe umbhalo.

Kunezindlela eziningi zokuguqula amaphuzu athembekile kumadokhumenti we-Excel. Iningi lalezi zinketho libonisa ukuguqula ifomethi yedatha ngombhalo wezinombolo. Lokhu kuholela eqinisweni lokuthi uhlelo alunakubandakanya lezi zinkulumo ekubaleni. Kepha futhi kunendlela yokwenza ushintsho lwamakhoma ngamaphoyinti ngenkathi ugcina ukufometha komthombo. Ukuze wenze lokhu, uzodinga ukushintsha izilungiselelo zohlelo uqobo.