Kutsiva madotsi nemakoma muExcel nenzira dzakasiyana

Kazhinji, uchishanda mumatafura eExcel, zvinove zvakakosha kutsiva madotsi nemakoma. Izvi zvinowanzokonzerwa nekuti munyika dzinotaura chiRungu doti rinoshandiswa kupatsanura zvikamu zvakapatsanurwa uye zvikamu zvese munhamba, nepo munyika yedu comma ichishandiswa kuita izvi.

Uye zvese zvingave zvakanaka, asi dambudziko nderekuti muRussified vhezheni yeExcel, data ine dot haina kunzwisiswa senhamba, izvo zvinoita kuti zvisaite kuti uwedzere kudzishandisa mukuverenga. Uye kugadzirisa izvi, unofanirwa kutsiva dot necomma. Izvi zvinogona kuitwa sei chaizvo muExcel, isu tichakurukura munyaya ino.

Method 1: Kushandisa Tsvaga uye Kutsiva Turusi

Tichatanga, zvichida, nzira iri nyore, iyo inosanganisira kushandiswa kwechishandiso “Tsvaga uye Tsiva”, kana uchishanda nayo yaunofanirwa kungwarira zvakanyanya kuti usaite netsaona kutsiva nguva nemakoma mune data apo izvi hazvifanirwe kuitwa (semuenzaniso, mumazuva). Saka heino mashandiro ayo:

1. Enda kune tab "Kumba", uye tinya bhatani "Tsvaga uye sarudza" (kukudza girazi icon) mubhuroka "Kugadzirisa". Rondedzero ichavhura patinosarudza murairo “Tsiva”. Kana kuti unogona kungodzvanya kiyi musanganiswa Ctrl + H.
2. Hwindo richaonekwa pachiratidziri. "Tsvaga uye Tsiva":
   • mumunda wekuisa kukosha kwakatarisana nechinhu “Wana” tinonyora chiratidzo "." (point);
   • muchikamu chakanzi “Siva ne”, nyora chikwangwani "," (comma);
   • dzvanya bhatani "Parameters".
3. Dzimwe sarudzo dzichaonekwa kuti iwe uite Tsvaga uye Kutsiva. Kudzvanya bhatani "Fomati" kune parameter “Yatsiviwa na”.
4. Muhwindo rinoonekwa, tsanangura chimiro chesero yakagadziriswa (iyo yatinowana pakupedzisira). Maererano nebasa redu, tinosarudza "Nhamba" fomati, wobva wadzvanya OK. Kana uchida, unogona kuseta nhamba yenzvimbo dzedesimali, pamwe nemapoka akaparadzana emanhamba nekuisa bhokisi rekutarisa rakakodzera.
5. Nekuda kweizvozvo, tichazviwana zvakare tiri pahwindo “Tsvaga uye Tsiva”. Pano isu tinofanirwa kusarudza nzvimbo yemasero umo mapoinzi achatsvagwa obva atsiviwa nemakoma. Zvikasadaro, kutsiva kuvhiyiwa kuchaitwa papepa rese, uye data risingafanirwe kunge rakashandurwa rinogona kukanganiswa. Kusarudza huwandu hwemasero kunoitwa nekudzvanywa bhatani rekuruboshwe. Dzvanya kana wagadzirira “Siva Zvose”.
6. Zvese zvagadzirira. Kuvhiya kwacho kwakapedzwa zvinobudirira, sezvinoratidzwa nehwindo reruzivo nehuwandu hwekutsiviwa kwakaitwa.
7. Isu tinovhara mahwindo ese (kunze kweExcel pachayo), mushure meizvozvo tinogona kuenderera mberi nekushanda neiyo yakashandurwa data mutafura.

Cherechedza: kuitira kuti usasarudza mutsara wemasero paunenge uchiisa maparameter muhwindo “Tsvaga uye Tsiva”, unogona kuzviita pachine nguva, kureva kuti tanga wasarudza maseru, wobva watanga chishandiso chakakodzera kuburikidza nemabhatani ari paribhoni rechirongwa kana kushandisa nzira yekudimbudzira keyboard. Ctrl + H.

Nzira 2: SUBSTITUTE basa

Ngatitarisei zvino basa racho "SUBSTITUTE", iyo inokubvumirawo kutsiva madotsi nemakoma. Asi kusiyana nenzira yatakurukura pamusoro apa, kutsiviwa kwehukoshi hakuitwe mune yekutanga, asi inoratidzwa mumaseru akasiyana.

1. Isu tinoenda kune yepamusoro sero yekoramu yatinoronga kuratidza data, mushure mezvo tinodzvanya bhatani "Isa basa" (fx) kuruboshwe rweformula bar.
2. Mufafitera rakavhurwa Basa Wizards sarudza chikamu - “Mashoko”, umo tinowana mushandisi "SUBSTITUTE", sarudza wobva wadzvanya OK.
3. Tichazviwana tiri pahwindo nemabasa nharo dzinoda kuzadzwa mukati:
   • mukukosha kwenharo “Mashoko” tsanangura zvinorongeka zvesero rekutanga rekoramu yaunoda kutsiva madotsi nemakoma. Iwe unogona kuita izvi nemaoko nekuisa kero uchishandisa makiyi pane keyboard. Kana kuti unogona kutanga wadzvanya mbeva mukati memunda kuti uise ruzivo, wobva wadzvanya pane yaunoda sero mutafura.
   • mukukosha kwenharo "Star_Text" tinonyora chiratidzo "." (point).
   • kuitira nharo “Chinyorwa_ chitsva” tsanangura chiratidzo seukoshi "," (comma).
   • kukosha kwenharo "Nhamba_yekupinda" angasazadzwa.
   • tinya kana wagadzirira OK.
4. Isu tinowana mhedzisiro inodiwa musero rakasarudzwa.
5. Inoramba ichingowedzera basa iri kune yasara mitsara yekoramu. Ehe, haufanirwe kuita izvi nemaoko, sezvo Excel iine basa rinoshanda rekuita. Kuti uite izvi, fambisa cursor kukona yezasi yekurudyi yesero neformula, kana chinongedzo chachinja kuita chitema plus chiratidzo (zadza chiratidzo), bata pasi bhatani rekuruboshwe uye woridhonzera pasi kumutsara wekupedzisira unobatanidzwa. kushandura data.
6. Inosara chete kufambisa iyo data yakashandurwa kunzvimbo iri patafura painofanira kunge iri. Kuti uite izvi, sarudza maseru ekoramu nemhedzisiro (kana sarudzo yakacheneswa mushure mekuita kwapfuura), tinya-kurudyi pane chero nzvimbo mune yakasarudzwa uye sarudza chinhu. "Kopa" (kana kuti tinya nzira yekudimbudzira keyboard Ctrl + C).
7. Zvadaro tinosarudza mutsara wakafanana wemasero mumutsara wepakutanga uyo data yakashandurwa. Isu tinya-kurudyi pane yakasarudzwa nzvimbo uye mune yemukati menyu inovhura, mune paste sarudzo, sarudza “Values”.
8. Mushure mekunamira iyo data yakakopwa, chiratidzo chekushamisika chinozoonekwa padivi payo. Dzvanya pairi uye sarudza kubva pakurongwa "Shandura kuita nhamba".
9. Zvese zvakagadzirira, isu tine koramu umo nguva dzese dzinotsiviwa nemakoma.
10. Chikamu chebasa chinoshandiswa kushanda nebasa SUBSTITUTE, haichadiwi uye inogona kubviswa kuburikidza nemenu yemukati. Kuti uite izvi, tinya-kurudyi pane zita rekoramu pane horizontal coordinate bar uye sarudza rairo kubva pane rondedzero inoonekwa. "Bvisa".
11. Izvo zviito zviri pamusoro, kana zvichidikanwa, zvinogona kuitwa maererano nemamwe makoramu etafura yekunobva.

Nzira 3: Kushandisa Macro

Macros zvakare inobvumidza iwe kutsiva dot necomma. Heino maitiro azvinoitwa:

1. Kutanga iwe unofanirwa kuve neshuwa kuti iyo tebhu yakagoneswa "Developer"iyo yakadzimwa nekusarudzika muExcel. Kugonesa iyo yaunoda tab, enda kune menyu "Faira".
2. Muchinyorwa chiri kuruboshwe, enda kuchikamu "Parameters".
3. Mune sarudzo dzechirongwa, tinya pachikamu "Customize Ribhoni", mushure mezvo, muchikamu chekurudyi chehwindo, isa chiratidzo pamberi pechinhu "Developer" uye baya OK.
4. Chinja kune tab "Developer"umo tinodzvanya bhatani "VisualBasic".
5. Mupepeti, tinya pane pepa ratinoda kutsiva, pahwindo rinovhurwa, isa kodhi pazasi, wobva wavhara mupepeti:

   Sub Макрос_замены_точки_на_запятую()

   Sarudzo.Siva Chii:=".", Replacement:=".", LookAt:=xlPart, _

   SearchOrder:=xlByRows, MatchCase:=Nhema, SearchFormat:=Nhema, _

   ReplaceFormat:=Nhema

   End Sub

6. Zvino sarudza huwandu hwemasero pane pepa ratinoronga kuita kutsiva, uye wobva wadzvanya bhatani "Macro" zvese mune imwechete tab "Developer".
7. Hwindo rinozaruka rine runyoro rwemacros, umo isu tinosarudza "Macro_replacing_dot_by_comma" uye sundidzira "Mhanya".
8. Nekuda kweizvozvo, tinozowana maseru ane data rakashandurwa, umo madotsi akatsiviwa nemakoma, ndizvo zvataida.

Nzira 4: Kushandisa Notepad

Iyi nzira inoshandiswa nekukopa data mupepeti yakavakwa muWindows operating system. notibhuku zvekugadzirisa gare gare. Iyo nzira inoratidzwa pazasi:

1. Kutanga, isu tinosarudza huwandu hwemasero muhutsika hwatinoda kutsiva madotsi nemakoma (ngatifungei imwe koramu semuenzaniso). Mushure meizvozvo, tinya-kurudyi pane chero nzvimbo munzvimbo yakasarudzwa uye sarudza murairo kubva kumenyu inovhura. "Kopa" (kana kuti unogona kushandisa nzira yekudimbudzira keyboard Ctrl + C).
2. manya notibhuku uye namatidza ruzivo rwakakopwa. Kuti uite izvi, tinya-kurudyi uye sarudza murairo kubva pane yekudonha-pasi menyu. “Isert” (kana kushandisa musanganiswa Ctrl + V).
3. Pamusoro pemenu bar, tinya pa "Gadzirisa". Rondedzero ichavhurwa, umo isu tinodzvanya pane murairo “Tsiva” (kana kudzvanya hotkeys Ctrl + H).
4. Iwindo diki rekutsiva richaonekwa pachiratidziri:
   • mumunda wekupinda parameter value “Chii” print character "." (point);
   • sekukosha kweparameter “Sei” isa chiratidzo "," (comma);
   • kusunda “Siva Zvose”.
5. Vhara hwindo rekutsiva. Sarudza iyo data yakashandurwa, wobva wadzvanya-kurudyi pairi uye sarudza rairo "Kopa" mune yemukati menyu inovhura (iwe unogona zvakare kushandisa Ctrl + C).
6. Ngatidzokerei kuExcel. Isu tinomaka nzvimbo yaunoda kuisa iyo yakashandurwa data. Wobva wadzvanya-kurudyi pane rakasarudzwa uye sarudza rairo “Chengeta mashoko chete” mune yekuisa sarudzo (kana tinya Ctrl + V).
7. Inosara chete kuseta iyo sero fomati se "Nhamba". Unogona kuzvisarudza mubhokisi rekushandisa “Nhamba” (tab "Kumba") nekudzvanya pane yazvino fomati uye kusarudza yaunoda.
8. Basa rakapedzwa zvinobudirira.

Nzira 5: Kuisa Excel Options

Nekushandisa nzira iyi, tinoda kushandura mamwe marongero ehurongwa.

1. Enda kumenyu "Faira", kwatinobaya pachikamu "Parameters".
2. Muzvirongwa zvepurogiramu mune runyorwa kuruboshwe, tinya pachikamu “Kuwedzera”… Muchivharo chezvigadziriso "Edit Options" bvisa bhokisi rekutarisa riri padivi pezvisarudzo "Shandisa masisitimu separators". Mushure maizvozvi, minda yekupinda mavara sevanoparadzanisa inovhurwa. Semupatsanuri wezvikamu zvakakwana uye zvikamu, tinonyora chiratidzo "." (dot) uye chengetedza marongero nekudzvanya bhatani OK.
3. Pachave pasina shanduko yekuona mutafura. Nokudaro, tinoenderera mberi. Kuti uite izvi, kopira iyo data uye unamate mukati notibhuku (ngatitarisei muenzaniso wekoramu imwe).
4. Kutora data kubva Notepad wopinza zvakare mutafura Excel munzvimbo imwechete yavakakopwa kubva. Kurongeka kwedata kwachinja kubva kuruboshwe kuenda kurudyi. Izvi zvinoreva kuti ikozvino purogiramu inoona izvi zvakakosha senhamba.
5. Dzokera kumagadzirirwo echirongwa (chikamu “Kuwedzera”), kwatinodzosera bhokisi rekutarisa rakatarisana nechinhu "Shandisa masisitimu separators" panzvimbo uye tinya bhatani OK.
6. Sezvauri kuona, madotsi akatsiviwa otomatiki nechirongwa nemakoma. Usakanganwa kushandura iyo data fomati kuti "Nhamba" uye unogona kushanda navo mberi.

Nzira 6: System Settings

Uye pakupedzisira, funga imwe nzira yakafanana neyakatsanangurwa pamusoro, asi inosanganisira kushandura marongero kwete eExcel, asi yeWindows inoshanda system.

1. Tinopinda Control panel munzira ipi neipi yakanakira. Somuenzaniso, izvi zvinogona kuitwa kuburikidza kutsvakanekunyora zita raunoda uye kusarudza yakawanikwa sarudzo.
2. Seta maonero sezvidhori zvidiki kana zvihombe, wobva wadzvanya pachikamu “Regional Standards”.
3. Iwindo rezvirongwa zvedunhu richaonekwa, umo, kuva mubhu "Fomati" tinya pane bhatani "Dzimwe marongero".
4. Muhwindo rinotevera rine maitiro ekugadzirisa, tinoona parameter "Integer/Decimal Separator" uye kukosha kwayo. Panzvimbo pekoma, nyora nguva wodzvanya OK.
5. Saizvozvo nenzira yechishanu yakakurukurwa pamusoro, tinokopa data kubva kuExcel kuenda notibhuku uye shure.
6. Isu tinodzosera zvigadziriso zvefomati kunzvimbo yavo yepakutanga. Ichi chiito chakakosha, sezvo zvisina kudaro zvikanganiso zvinogona kuitika mukushanda kwezvimwe zvirongwa uye zvinoshandiswa.
7. Madotsi ese ari muchikamu chataishanda akatsiviwa nemakoma.

mhedziso

Saka, Excel inopa 5 nzira dzakasiyana, uchishandisa iyo iwe yaunogona kutsiva madotsi nemakoma, kana zvakadaro kudiwa kwakamuka panguva yebasa. Mukuwedzera, iwe unogona kushandisa imwe nzira, iyo inosanganisira kuchinja kune zvigadziro zveWindows operating system pachayo, iyo Excel yakaiswa.