Kusintha makoma ndi madontho mu Excel: Njira 5

Kuti tilekanitse magawo onse ndi magawo a nambala yomwe imayimiridwa ngati gawo la decimal, cholekanitsa chapadera chimagwiritsidwa ntchito: m'mayiko olankhula Chingerezi ndi kadontho, kotsalako nthawi zambiri ndi koma. Chifukwa cha kusiyana kumeneku, ogwiritsa ntchito Excel nthawi zambiri amakumana ndi ntchito yosintha zilembo zina ndi zomwe amafunikira. Tiyeni tiwone momwe mungasinthire makoma kukhala madontho mu pulogalamuyi.

Zindikirani: ngati comma igwiritsidwa ntchito ngati cholekanitsa, ndiye kuti pulogalamuyo sidzavomereza manambala okhala ndi madontho ngati magawo a decimal, zomwe zikutanthauza kuti sangagwiritsidwenso ntchito powerengera. Izi ndizoonanso pazochitika zina.

Njira 1: Gwiritsani Ntchito Pezani ndi Kusintha Chida

Njira imeneyi ndi yotchuka kwambiri ndipo imaphatikizapo kugwiritsa ntchito chida "Pezani ndi Kusintha M'malo":

1. Munjira iliyonse yabwino, timasankha ma cell angapo momwe makoma onse ayenera kusinthidwa ndi madontho. Muzolowera zazikulu mu chipika "Editing" dinani chizindikiro cha ntchito "Pezani ndikusankha" ndipo muzosankha zomwe zaperekedwa timayima pa chisankho - "Bwezerani". Mukhozanso kugwiritsa ntchito njira yachidule ya kiyibodi kuyambitsa chida ichi. Ctrl + H.Zindikirani: ngati simupanga chisankho musanagwiritse ntchito chida, ndiye kuti kusaka ndikusintha ma comma ndi nthawi kumachitidwa pazomwe zili patsambalo, zomwe sizofunikira nthawi zonse.
2. A yaing'ono ntchito zenera adzaoneka pa zenera. “Pezani ndi Kusintha”. Nthawi yomweyo tiyenera kukhala mu tabu "Bwezerani" (ngati pazifukwa zina izi sizinachitike, timasinthira pamanja). Pano ife tiri mu mtengo wa parameter "Pezani" tchulani chizindikiro cha koma “Kusinthidwa ndi” - chizindikiro cha dontho. Dinani batani mukakonzeka “Sinthani Zonse”kugwiritsa ntchito chida pamaselo onse osankhidwa.Kukanikiza batani lomwelo "Bwezerani" idzachita kusaka kumodzi ndikusintha, kuyambira pa selo yoyamba ya mtundu wosankhidwa, mwachitsanzo, ifunika kudina ndendende kangapo momwe pali zosinthira malinga ndi magawo omwe aperekedwa.
3. Kenako zenera adzakhala ndi zambiri za chiwerengero cha m'malo anachita.
4. Motero, popanda kuchita khama, tinatha kuyika madontho m’malo mwa koma m’chidutswa chosankhidwa cha tebulolo.

Njira 2: gwiritsani ntchito "M'malo".

Ndi ntchitoyi, mutha kusaka ndikusintha zilembo zina ndi zina. Nazi zomwe timachita:

1. Timadzuka mu cell yopanda kanthu pafupi ndi yomwe ili ndi koma (mu mzere womwewo, koma osati mumzere wotsatira). Kenako dinani chizindikirocho "Isert ntchito" kumanzere kwa formula bar.
2. Pa zenera lotseguka Zoyikapo dinani gulu lapano ndikusankha "Mawu" (zoyeneranso “Mndandanda wa zilembo zonse”). Pamndandanda womwe waperekedwa, chongani wogwiritsa ntchito "SUBSTITUTE", kenako panikizani OK.
3. Iwindo lidzawonekera momwe muyenera kudzaza mikangano yantchito:
   • "Mawu": Tchulani zolozera ku selo loyambirira lomwe lili ndi koma. Mutha kuchita izi pamanja polemba adilesi pogwiritsa ntchito kiyibodi. Kapena, pokhala m'munda wolowetsa zambiri, dinani chinthu chomwe mukufuna patebulo lomwe.
   • "Star_Text": apa, monga ndi ntchito “Pezani ndi Kusintha”, sonyezani chizindikiro choti chisinthidwe, mwachitsanzo koma (koma nthawi ino m’ma quotation marks).
   • "Zatsopano_mawu": tchulani chizindikiro cha kadontho (m'mawu obwereza).
   • "Nambala_yolowera" si kutsutsana kofunikira. Pamenepa, siyani munda wopanda kanthu.
   • Mutha kusintha pakati pa mikangano yantchito pongodinanso mkati mwa gawo lomwe mukufuna kapena kugwiritsa ntchito kiyi Tab pa keyboard. Zonse zikakonzeka, dinani OK.
4. Timapeza deta yokonzedwa mu selo ndi woyendetsa. Kuti mupeze zotsatira zofananira pazinthu zina zazanja, gwiritsani ntchito lembani chikhomo. Kuti muchite izi, yang'anani pakona yakumanja kwa selo ndi ntchitoyo. Cholozeracho chikangosintha kukhala chizindikiro chakuda chophatikiza (izi ndi pentopeni), gwirani batani lakumanzere la mbewa ndikulikokera mpaka kumapeto kwa gawolo.
5. Potulutsa batani la mbewa, tiwona zotsatira zake nthawi yomweyo. Zimangotsala kusuntha deta yatsopano patebulo, m'malo mwa oyambirirawo. Kuti muchite izi, sankhani ma cell omwe ali ndi mafomu (ngati kusankha kudachotsedwa mwadzidzidzi), dinani kumanja pamalo olembedwa ndikusankha chinthucho mumenyu yomwe imatsegulidwa. "Koperani".Mutha kugwiritsanso ntchito batani lofananira lomwe lili mubokosi lazida "Clipboard" mu tabu yayikulu ya pulogalamuyo. Kapena ingodinani ma hotkeys Ctrl + C.
6. Tsopano timasankha ma cell angapo patebulo lokha, pomwe tiyenera kumata zomwe zidakopera pa clipboard. Dinani kumanja pagawo losankhidwa, mu menyu yomwe imatsegulidwa "Paste Options" sankhani chizindikirocho ndi chithunzi cha chikwatu ndi manambala 123, - lamulo “Ikani Makhalidwe”.Zindikirani: M'malo mosankha mndandanda pa tebulo loyambira, mutha kusuntha kupita ku selo lapamwamba kwambiri (kapena selo lapamwamba kumanzere kwambiri, ngati tikukamba za malo okhala ndi mizere ingapo ndi mizere), kuyambira pomwe mukufuna. sungani zomwe mwakopera.
7. Makoma onse omwe ali mugawoli asinthidwa ndi nthawi. Sitifunikiranso gawo lothandizira, ndipo titha kulichotsa. Kuti muchite izi, dinani chizindikiro chake pa bar yopingasa yolumikizira ndi batani lakumanja la mbewa ndi menyu yomwe imatsegulidwa, imani pa lamulo. "Chotsani". Mukamachita opareshoni, muyenera kuwonetsetsa kuti palibe deta yofunikira m'mizere yomwe ili pansipa, yomwe idzachotsedwenso.Njira ina ndiyo kuchotsa zomwe zili m'maselo. Kuti muchite izi, sankhani, imbani mndandanda wazotsatira ndikudina kumanja ndikusankha lamulo loyenera pamndandanda womwe umatsegulidwa.

Njira 3: Sinthani Zosankha za Excel

Tiyeni tipitirire ku njira yotsatira, yomwe imasiyana ndi zomwe takambirana pamwambapa chifukwa sitidzachitapo kanthu m'malo ogwirira ntchito (papepala), koma pazokonda zake.

Zindikirani kuti, zomwe mukufuna kuchita m'malo mwake, ziyenera kusankhidwa ngati Zambiri (kapena General) kuti pulogalamuyo izindikire zomwe zilimo ngati manambala ndikugwiritsa ntchito zoikamo zomwe zafotokozedwa kwa iwo. Ndiye tiyeni tiyambe:

1. Pitani ku menyu "Fayilo".
2. Sankhani chinthu kuchokera pamndandanda womwe uli kumanzere "Parameters".
3. M'kagawo kakang'ono "Zowonjezera" chotsani kusankha "Gwiritsani ntchito zolekanitsa dongosolo" (parameter group "Sintha Zosankha"), pambuyo pake gawo lotsutsana limatsegulidwa "Integer and fraction separator", mmene timasonyezera chizindikiro "mfundo" ndipo dinani OK.
4. Chifukwa chake, ma koma adzasinthidwa ndi madontho m'maselo onse okhala ndi manambala. Zochitazi zidzachitika m'buku lonse lantchito, osati papepalali lokha.

Njira 4: Gwiritsani Ntchito Mwambo Macro

Njirayi singatchulidwe kuti ndi yotchuka, komabe, ilipo, kotero tidzalongosola.

Choyamba, tiyenera kukonzekera koyambirira, ndiko, yambitsani mode mapulogalamu (yozimitsa mwachisawawa). Kuti muchite izi, mu magawo a pulogalamuyo m'chigawocho "Sinthani Riboni" kumanja kwa zenera, chongani bokosi pafupi ndi katunduyo "Developer". Tsimikizirani zosintha podina batani OK.

Tsopano tiyeni titsike ku ntchito yathu yayikulu:

1. Kusintha kwa tabu yomwe ikuwoneka "Developer" dinani chizindikiro chakumanzere kwa riboni "Visual Basic" (gulu la zida "kodi").
2. Iwindo lidzawonekera pazenera. Mkonzi wa Microsoft VB. Kumanzere, dinani kawiri pa pepala kapena bukhu lililonse. M'munda womwe ukutsegulidwa, ikani kachidindo pansipa ndikutseka mkonzi.

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

   Selection.Bwezerani Zomwe:=",", Replacement:=".", LookAt:=xlPart, _

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

   ReplaceFormat:=Zabodza

   mapeto Sub

3. Timasankha ma cell omwe mukufuna kusintha. Kenako dinani chizindikirocho "Macro".
4. Pazenera lomwe likuwoneka, lembani ma macro athu ndikutsimikizira kuchitidwa kwa lamulolo podina batani loyenera. Chonde dziwani kuti sichingasinthidwe.
5. Zotsatira zake, makoma onse m'maselo osankhidwa adzasinthidwa ndi madontho.

Zindikirani: Njirayi imagwira ntchito pokhapokha ngati mfundo ikugwiritsidwa ntchito ngati cholekanitsa decimal mu pulogalamuyo, mwachitsanzo "Gwiritsani ntchito zolekanitsa dongosolo" (zakambidwa pamwambapa) ndizolephereka.

Njira 5: Sinthani machitidwe a makompyuta

Timalize m'njira yomwe imaphatikizapo kusintha makonda a opareshoni yokha (tiyeni tiwone chitsanzo cha Windows 10).

1. Thamangani Gawo lowongolera (mwachitsanzo, kudzera pa mzere Search).
2. Mu mawonekedwe "Zithunzi zazing'ono / zazikulu" dinani applet “Regional Standards”.
3. Pazenera lomwe limatsegulidwa, tipeza tabu "Mtundu"momwe timadina batani "Zowonjezera zina".
4. Mu zenera lotsatira mu tabu "Nambala" titha kutchula mawonekedwe a delimiter omwe tikufuna kuyika ngati osasintha pamakina komanso pulogalamu ya Excel makamaka. Kwa ife, iyi ndi mfundo. Dinani pamene mwakonzeka OK.
5. Pambuyo pake, makoma onse m'maselo a tebulo omwe ali ndi chiwerengero cha manambala (ndi mtundu - Zambiri or General) adzasinthidwa ndi madontho.

Kutsiliza

Chifukwa chake, pali njira zingapo mu Excel zomwe mungagwiritse ntchito m'malo mwa makoma ndi nthawi m'maselo a tebulo. Nthawi zambiri, uku ndiko kugwiritsa ntchito chida cha Pezani ndi Kusintha, komanso ntchito ya SUBSTITUTE. Njira zina ndizofunika pazochitika zapadera ndipo zimagwiritsidwa ntchito mocheperapo.