Kusintha komma ndi nthawi ku Microsoft Excel

Amadziwika kuti mu mtundu wa Russia wa Excel, comma imagwiritsidwa ntchito ngati gawo logawanitsa, pomwe mu Chingerezi nthawi imagwiritsidwa ntchito. Izi ndichifukwa chakupezeka kwa miyezo yosiyanasiyana m'munda uno. Kuphatikiza apo, m'maiko olankhula Chingerezi ndichizolowezi kugwiritsa ntchito comma ngati olekanitsa, ndipo kwa ife nthawi. Nawonso, izi zimayambitsa vuto pamene wosuta atsegula fayilo yopangidwa mu pulogalamu yodziyimira payokha. Zimafika pamenepa kuti Excel saganizira ngakhale zamawonekedwe, chifukwa amawona molakwika. Pankhaniyi, muyenera kusintha kusintha kwawomwe pulogalamuyo ikusintha, kapena kusintha zilembo zomwe zalembedwa. Tiyeni tiwone momwe angasinthire comma kuti ikhale pamutuwu.

Njira yosinthira

Musanapitirize ndi kulowererapo, muyenera kumvetsetsa nokha zomwe mukuchitirazo. Ndi chinthu chimodzi ngati muchita izi pokhapokha chifukwa mumazindikira mfundozo ngati zopatula ndipo simukonzekera kugwiritsa ntchito manambalawa pakuwerengera. Ndi nkhani ina ngati mungafunike kusintha chizindikirocho molondola, chifukwa m'tsogolomo chikalatacho chikhala mu Chichewa cha Excel.

Njira 1: pezani ndi Chida chosinthira

Njira yosavuta yosinthira kometi ndikugwiritsa ntchito chida Pezani ndi Kusintha. Koma, ziyenera kudziwika nthawi yomweyo kuti njirayi sioyenera kuwerengera, chifukwa zomwe zili m'maselozo zidzasinthidwa kukhala zolemba.

1. Timasankha m'deralo pepala pomwe mukufuna kuti musintheko kukhala ma point. Chitani mbewa kumanja. Pazosankha zomwe zikuyamba, yikani chizindikiro "Mtundu wamtundu ...". Ogwiritsa ntchito omwe amakonda kugwiritsa ntchito njira zina pogwiritsa ntchito "makiyi otentha", atatha kuwunikira, atha kuylemba makiyi Ctrl + 1.



2. Tsamba losintha limayambitsidwa. Pitani ku tabu "Chiwerengero". Gululi gulu "Mawerengero Amanambala" sinthani kusankha kwa malo "Zolemba". Kuti musunge zosintha, dinani batani "Zabwino". Mtundu wa data mumtundu wosankhidwa udzasinthidwa kukhala mawu.



3. Ndiponso, sankhani mtundu womwe mukufuna. Izi ndizofunikira, chifukwa popanda kudzipatula koyambirira, kusinthaku kudzachitika kudera lonse la pepala, ndipo izi ndizofunikira nthawi zonse. Deralo likasankhidwa, pitani ku tabu "Pofikira". Dinani batani Pezani ndikuwunikirayomwe ili mgululi "Kusintha" pa tepi. Kenako menyu yaying'ono imatsegulidwa, yomwe muyenera kusankha "Bweretsani ...".



4. Pambuyo pake, chida chimayamba Pezani ndi Kusintha pa tabu M'malo. M'munda Pezani ikani chikwangwani ",", ndi m'munda "M'malo ndi" - ".". Dinani batani Sinthani Zonse.



5. Tsamba lazidziwitso limatseguka pomwe lipoti la kusinthidwa kwamaliza limaperekedwa. Dinani batani "Zabwino".

Pulogalamuyi imagwira ntchito yosintha ndalama kuzinthu zomwe zasankhidwa. Pamenepa, vutoli lingathe kuthandizidwa. Koma ziyenera kukumbukiridwa kuti zomwe zasinthidwa motere zimakhala ndi mawonekedwe, ndipo, chifukwa chake, sizingagwiritsidwe ntchito powerengera.

Phunziro: M'malo mwa Khalidwe ku Excel

Njira 2: kutsatira ntchito

Njira yachiwiri imaphatikizapo kugwiritsa ntchito wothandizira SUBSTITUTE. Poyamba, pogwiritsa ntchito ntchitoyi, timasinthira zosiyanazo m'malo osiyanasiyana, kenako ndikuzikopera kumalo oyamba.

1. Sankhani khungu lopanda kanthu moyang'anizana ndi selo loyamba lazosankha momwe ma komasi amayenera kusinthidwira kukhala mfundo. Dinani pachizindikiro. "Ikani ntchito"atayikidwa kumanzere kwa barula yamu formula.



2. Pambuyo pa izi, Wizard Yogwira Ntchito idzayambitsidwa. Tikuyang'ana m'gulululi "Yesani" kapena "Mndandanda wathunthu wa zilembo" dzina SUBSTITUTE. Sankhani ndikudina batani. "Zabwino".



3. Ntchito yotsutsana ndi ntchito imatsegulidwa. Ali ndi zifukwa zitatu zofunika. "Zolemba", "Zolemba zakale" ndi "Zolemba zatsopano". M'munda "Zolemba" muyenera kutchula adilesi ya foni komwe kuli komwe kuli deta, yomwe ikuyenera kusinthidwa. Kuti muchite izi, ikani cholozera m'munda uno, kenako dinani pepala loyamba la mitundu yosiyanasiyana. Zitangochitika izi, adilesi imawonekera pazenera zotsutsana. M'munda "Zolemba zakale" khalani wotsatira - ",". M'munda "Zolemba zatsopano" lembani mfundo - ".". Pambuyo poti pulogalamuyo yaikidwa, dinani batani "Zabwino".



4. Monga mukuwonera, kutembenuka kunayenda bwino kwa foni yoyamba. Ntchito yofananayi itha kuchitika maselo ena onse omwe angafunike. Ngati izi zili zochepa. Koma bwanji ngati ili ndi maselo ambiri? Zowonadi, kusinthika mwanjira iyi, pankhaniyi, kudzatenga nthawi yayitali. Koma, ndondomekoyi ikhoza kupititsidwa patsogolo mwakutsatira formula SUBSTITUTE kugwiritsa ntchito chikhomo.

   Timayika cholowera pamphepete kumanja kwa selo yomwe ntchitoyo imakhalamo. Chizindikiro chodzaza ndikuwoneka ngati mtanda wawung'ono. Gwirani batani lakumanzere ndikudula mbali iyi kuti igwirizane ndi dera lomwe mukufuna kusintha ndalama kukhala nambala.



5. Monga mukuwonera, zonse zomwe zidasungidwa pazomwe zidasinthidwa zidasinthidwa kukhala zidziwitso ndi nthawi m'malo mwa ndalama. Tsopano muyenera kukopera zotsatirazi ndikuziwunika mu gwero. Sankhani maselo okhala ndi mawonekedwe. Kukhala mu tabu "Pofikira"dinani pa batani pa riboni Copyili pagulu lazida Clipboard. Itha kupangidwa kukhala yosavuta, monga, posankha mtundu, lembani kuphatikiza mafungulo pa kiyibodi Ctrl + 1.



6. Sankhani magwero. Timadina pamasankhidwe ndi batani la mbewa yoyenera. Zosintha zamakina zikuwoneka. Mmenemo, dinani chinthucho "Makhalidwe"lomwe lili mgululi Ikani Zosankha. Katunduyu akuwonetsedwa ndi manambala. "123".



7. Zitatha izi, mfundozo zimayikidwa mgawo loyenerera. Potere, ma comas asinthidwa kukhala ma point. Kuti tichotse malo omwe sitikufunanso, odzadza ndi mafomu, sankhani ndikudina-kumanja. Pazosankha zomwe zimapezeka, sankhani Chotsani Zolemba.

Kusintha kwa ma comma-to-dot data kwatsirizidwa, ndipo zinthu zonse zosafunikira zichotsedwa.

Phunziro: Ntchito Wizard ku Excel

Njira 3: Kugwiritsa ntchito Macro

Njira yotsatira yosinthira ma comas ku ma point ndikugwiritsa ntchito macros. Koma, chinthu ndichakuti ma macros ku Excel ndi olemala mosakhazikika.

Choyambirira, onetsetsani macros ndikuyambitsa tabu "Wopanga"ngati mu pulogalamu yanu sakadalipo. Pambuyo pake, muyenera kuchita izi:

1. Pitani ku tabu "Wopanga" ndipo dinani batani "Zowoneka Zachikulu"yomwe ili mgululi "Code" pa tepi.



2. Wokonza macro amatsegula. Lowetsani zotsatirazi:

   Sub Comma_Transfform_Macro_Macro ()
Kusankha.Replace Kodi: = ",", M'malo: = "."
Mapeto sub

   Timaliza mkonzi pogwiritsa ntchito njira yofananira podina batani loyandikira pakona yakumanja.



3. Kenako, sankhani mtundu womwe kusinthaku kuyenera kuchitikira. Dinani batani Macrosomwe amapezeka onse mgulu limodzi la zida "Code".



4. Windo limatsegulidwa ndi mndandanda wa macros omwe akupezeka m'buku. Sankhani yomwe idapangidwa posachedwa kudzera mwa osintha. Pambuyo powunikira mzerewo ndi dzina lake, dinani batani Thamanga.

Kutembenuka kukuchitika. Ma Commas asinthidwa kukhala madontho.

Phunziro: Momwe mungapangire zazikulu mu Excel

Njira 4: Makonda a Excel

Njira yotsatira ndi yokhayo pamwambapa, momwe mukasinthira makina kukhala madontho, mawuwo amadziwika ndi pulogalamuyo ngati nambala, osati monga mawu. Kuti tichite izi, tifunikira kuti tisinthe makina oyeserera mu zoikamo ndi semicolon kufikira pomwepo.

1. Kukhala mu tabu Fayilo, dinani pa dzina la block "Zosankha".



2. Pazenera losankha, sinthani ku gawo laling'ono "Zotsogola". Timafufuza makonda Sinthani Zosankha. Tsegulani bokosi pafupi ndi mtengo wake "Gwiritsani ntchito olekanitsa dongosolo". Ndiye ku "Osiyanitsa kwathunthu ndi magawo awiri" sinthanani ndi "," pa ".". Kuti mulowetse magawo, dinani batani "Zabwino".

Pambuyo pa magawo omwe ali pamwambapa, ma comma omwe adagwiritsidwa ntchito ngati olekanitsidwa ndi tizigawo asinthidwa kukhala mfundo. Koma, chofunikira kwambiri, ziganizo zomwe adagwiritsa ntchito zizikhala zopanda manambala, ndipo sizidzasinthidwa kukhala zolemba.

Pali njira zingapo zosinthira ndalama kuti zikhale nthawi muzolemba za Excel. Zambiri mwa zosankha izi zimaphatikizapo kusintha mtundu wamtundu kuchokera ku nambala kupita pamawu. Izi zimabweretsa kuti pulogalamuyi siyingagwiritse ntchito mawerengedwa awa. Komanso pali njira yosinthira ma comas kukhala madontho pomwe mukusunga zojambula zoyambirira. Kuti muchite izi, muyenera kusintha kusintha kwa pulogalamuyo.