Njira 5 Zosinthira Ma Commas ndi Madontho mu Excel

Pantchito ya pulogalamu ya Excel, chilichonse chimagwira ntchito molingana ndi mafomu ndi magwiridwe antchito. Ngakhale chifukwa cha kadontho kamodzi kapena koma, kusunga kabuku konseko kungalephereke. Ndipo izi zikutanthauza kuti zidzakhala zothandiza kwa aliyense wogwiritsa ntchito pulogalamuyi kuti aphunzire momwe angapezere mwamsanga cholakwikacho ndikuchikonza.

Njira zosinthira

Mu mtundu wa Excel, comma imagwiritsidwa ntchito kutanthauza zigawo za decimal, koma mu pulogalamu ya Chingerezi, madontho amagwiritsidwa ntchito. Nthawi zambiri zolakwika izi zimachitika chifukwa chogwira ntchito m'zilankhulo ziwiri kapena chifukwa chosowa chidziwitso.

Poyamba, ndi bwino kusankha pazifukwa zimene zinakhala kofunika kusintha koma ndi dontho. Nthawi zina, izi zimachitika chifukwa cha mawonekedwe owoneka bwino m'malo mogwiritsa ntchito zofunikira. Koma ngati choloŵa m'malo chikutsatiridwa ndi kufunikira kwa mawerengedwe, ndiye kusankha njira yosinthira makoma ndi madontho kuyenera kuganiziridwa mozama. Malingana ndi cholinga cha kusintha, njirayo idzakhala yosiyana.

Njira 1: Gwiritsani Ntchito Pezani ndi Kusintha Chida

Imodzi mwa njira zosavuta komanso zodziwika bwino zosinthira koma ndi kadontho ndiyo kugwiritsa ntchito chida chotchedwa Pezani ndi Kusintha. Tsoka ilo, njira iyi si yoyenera pazigawo zogwira ntchito. Mukasintha comma ndi kadontho pogwiritsa ntchito njirayi, ma cell amasinthidwa kukhala zolemba. Ganizirani njira ya Find and Replace njira:

1. Timasankha ma cell angapo omwe akufunika kusinthidwa. Mukadina kumanja pagawo lomwe mwasankha, menyu imatuluka. Apa timasankha chinthu chotchedwa "Format Cells". Izi zitha kutchedwa ndi njira yachidule ya kiyibodi Ctrl + 1.
2. Pamene "Maselo a Format" atsegulidwa, zenera la masanjidwe limatsegulidwa. Mu "Number" parameter, sankhani "Text". Kuti musunge zosintha zomwe zachitika, onetsetsani kuti dinani "Chabwino". Ngati mungotseka zenera la masanjidwe, ndiye kuti zosintha zonse zidzataya mphamvu.
3. Tiyeni tipitirire ku sitepe yotsatira. Apanso, sankhani nambala yofunikira ya maselo. Mu tabu yogwira "Home" timapeza chipika cha ntchito "Kusintha", sankhani "Pezani ndikusankha". Pazosankha zomwe zikuwonekera pambuyo pa izi, njira ya "Replace" iyenera kutsegulidwa.

4. Pambuyo pake, zenera lotchedwa "Pezani ndi Kusintha" limatsegulidwa kuti mudzaze magawo awiri a "Pezani" - munthu, mawu kapena nambala yalowetsedwa, ndipo mu "Bwezerani ndi" muyenera kutchula khalidwe, mawu kapena nambala yomwe idzalowe m'malo. zopangidwa. Choncho, mu mzere "Pezani" padzakhala "," chizindikiro, ndi mzere "Bwezerani" - "".
5. Pambuyo podzaza magawo, dinani "Bwezerani Zonse". Pambuyo pake, uthenga wawung'ono udzawoneka wokhudza kuchuluka kwa zomwe zasinthidwa. Dinani "Chabwino".

Njirayi imakulolani kuti musinthe ma comma onse ndi nthawi m'malo osankhidwa a ma cell. Ndondomekoyi ndi yosavuta komanso yachangu. Choyipa cha njirayi ndikusintha mawonekedwe ndi mawu amodzi, omwe samaphatikizapo kuwerengera kwina kulikonse.

Njira 2: Gwiritsani ntchito SUBSTITUTE Ntchito

Njirayi imachokera pakugwiritsa ntchito ntchito yofananira ya dzina lomwelo. Posankha njirayi, m'pofunika kutembenuza deta ya selo, ndikuyikopera ndikuyiyika m'malo mwa deta yoyambirira.

1. Posankha selo yopanda kanthu, pafupi ndi selo yomwe ingasinthe. Yambitsani "Ikani ntchito" - chizindikiro mu mzere wa ntchito "fx".
2. Pazenera lomwe likuwoneka ndi ntchito zomwe zilipo, timapeza gawo la "Text". Sankhani chilinganizo chotchedwa "M'malo" ndikusunga zosankhidwazo pokanikiza batani "Chabwino".

3. Zenera likuwonekera kuti mudzaze magawo ofunikira - "Zolemba", "Zolemba Zakale" ndi "Zolemba Zatsopano". "Text" parameter ikuphatikizapo kulowetsa adilesi ya selo ndi mtengo woyambirira. Mzere wakuti "Zolemba Zakale" cholinga chake ndi kusonyeza zilembo zomwe ziyenera kusinthidwa, zomwe ndi, ",", ndi "New text" parameter timayika "." Pamene magawo onse adzazidwa, dinani OK. Zotsatirazi ziwoneka mu cell yogwira: = SUBSTITUTE(C4; “,”; “.”).

4. Zotsatira zake, mtengo wa selo umasinthidwa bwino. Izi zikuyenera kubwerezedwanso kwa ma cell ena onse.
5. Njirayi ilinso ndi vuto lalikulu. Ngati zikhalidwe zochepa zokha ziyenera kusinthidwa, kubwereza masitepe sikutenga nthawi yayitali. Koma bwanji ngati mukufunika kusintha ma data ambiri. Mwachitsanzo, mutha kugwiritsa ntchito chikhomo chodzaza ma cell.
6. Kuti mugwiritse ntchito chinthuchi, muyenera kuyika cholozera pakona yakumanja ya cell yogwira ndi ntchito yomwe yalowa kale. Pankhaniyi, mtanda udzawonekera - chotchedwa chizindikiro chodzaza. Mwa kuwonekera pa batani lakumanzere la mbewa, muyenera kukokera mtandawo pamzerewu ndi mfundo zomwe ziyenera kusinthidwa.
7. Zotsatira zake, zikhalidwe zomwe zasinthidwa kale zidzawonekera pagawo losankhidwa - m'malo mwa makoma mu magawo a decimal, tsopano pali madontho. Tsopano muyenera kukopera ndi kusamutsa zonse zomwe mwapeza zosinthidwa kumaselo a manambala oyambirira. Onetsani maselo osinthidwa. Dinani batani "Koperani" pa "Main" tabu.
8. Mukadina kumanja pa mbewa yamakompyuta pamaselo osankhidwa, menyu amawonekera ndi gulu la "Paste Options", pezani ndikusankha "Values" parameter. Mwadongosolo, chinthuchi chikuwonetsedwa ngati batani "123".
9. Makhalidwe osinthidwa adzasunthidwa ku maselo oyenera. Kuti muchotse zinthu zosafunikira pamndandanda womwewo, sankhani gulu "Chotsani zomwe zili".

Chifukwa chake, kusinthidwa kwa ma commas kwa nthawi mumitundu yosankhidwa kwachitika, ndipo zosafunika zachotsedwa.

Njira 3: Sinthani Zosankha za Excel

Posintha magawo ena a pulogalamu ya Excel, muthanso kusinthanso chizindikiro "," ndi "". Pamenepa, mawonekedwe a maselo adzakhalabe manambala, ndipo sasintha kukhala malemba.

1. Ndi yambitsa "Fayilo" tabu, kusankha "Zosankha" chipika.
2. Muyenera kupita ku "Zapamwamba" gulu ndi kupeza "Sintha Mungasankhe". Chotsani chizindikiro pafupi ndi "Gwiritsani ntchito zolekanitsa dongosolo". Mu mzere wa "Separator of integer and fractional parts" timasintha dontho, lomwe ndilokhazikika, kukhala comma.

Pambuyo pa zosintha zomwe zidachitika pamakonzedwe a pulogalamu ya Excel, chotsitsa choyimira tizigawo tsopano ndi nthawi.

Njira 4: Gwiritsani Ntchito Mwambo Macro

Njira ina yosinthira ma semicolons mu Excel imakhudza kugwiritsa ntchito ma macros. Koma musanagwiritse ntchito, muyenera kuganizira kuti macros amayimitsidwa mwachisawawa mu pulogalamuyi. Chifukwa chake, kuti muyambe, muyenera kutsegula tabu ya "Developer" ndikuyambitsa ma macros.

Njira ya "Developer" imayatsidwa kudzera pazokonda pulogalamu. M'chigawo chotchedwa "Sinthani riboni", ndiye m'gulu la "Main tabu" timapeza chinthucho "Developer", kutsogolo komwe timayika chizindikiro. Zikhazikiko adamulowetsa pambuyo kukanikiza "Chabwino" batani.

1. Tab "Mapulogalamu" → block "Code", dinani batani lotchedwa "Visual Basic".
2. Zenera la macro editor lidzatsegulidwa. Pazenera ili, muyenera kuyika pulogalamu yotsatirayi:

Pakadali pano, timamaliza ntchitoyo mumkonzi mwa kungotseka zenera la mkonzi.

3. Sankhani ma cell omwe kusinthako kudzapangidwira. Dinani batani la "Macros", lomwe lili mubokosi lazida.
4. Iwindo likuwonekera likuwonetsa macros omwe alipo. Sankhani macro opangidwa kumene. Ndi macro omwe asankhidwa, dinani "Thamangani" kuti muyambitse.

5. Kusintha kwachitika - madontho adawonekera m'malo mwa koma.

Kugwiritsa ntchito njirayi kumafuna chisamaliro chapadera. Pambuyo poyambitsa macro, sizingatheke kubwezera zonse. Posankha ma cell omwe ali ndi zikhalidwe zina, muyenera kuwonetsetsa kuti zosintha zidzangochitika ku data yomwe ikufunika.

Njira 5: Sinthani machitidwe a makompyuta

Njirayi siyodziwika kwambiri, komabe, imagwiritsidwanso ntchito m'malo mwa makoma ndi nthawi powerengera muzolemba za Excel. Tidzasintha zoikamo mwachindunji mu mapulogalamu. Ganizirani izi pogwiritsa ntchito chitsanzo cha Windows 10 Pro software.

1. Timapita ku "Control Panel", yomwe imatchedwa "Start".

2. Mu gulu la "Nthawi ndi chinenero", sankhani "Region" njira.
3. Pambuyo pake, zenera lidzatsegulidwa. Apa tikuyambitsa "Zosankha zina za tsiku, nthawi, dera".

4. Zenera latsopano lidzatsegulidwa, momwe timapita ku "Regional Standards".

5. Tsopano kupita ku "Formats" tabu ndi pansi pa zenera yambitsa "MwaukadauloZida options ...".

6. Kenako, m'gulu la "Nambala", tchulani wolekanitsa wofunikira pamzere "Olekanitsa magawo onse ndi magawo ochepa." Pambuyo kusintha, dinani "Chabwino".

Chifukwa cha ntchito yathu, makoma m'maselo a matebulo a Excel odzazidwa ndi manambala amasinthidwa kukhala nthawi. Pamenepa, mawonekedwe a selo alibe kanthu, kaya ndi "General" kapena "Numeric".

Zofunika! Mukasamutsa fayilo ku kompyuta ina yokhala ndi zoikamo zokhazikika, zovuta zowerengera zimatha kuchitika.

Njira yowonjezera: Kusintha kadontho ndi comma mu Excel pogwiritsa ntchito Notepad

Mapulogalamu a Windows ali ndi pulogalamu ya Notepad yomwe imagwira ntchito potengera kuchuluka kwa ntchito ndi zoikamo. "Notepad" itha kugwiritsidwa ntchito ngati mkhalapakati wakopera, kuwoneratu deta.

1. Muyenera kusankha mtundu womwe mukufuna ndikutengera. Tsegulani Notepad ndikumata zomwe mwakopera pawindo lomwe limatsegula.

2. Pa tabu ya "Sinthani", sankhani gulu la "Bwezerani". Monga makiyi otentha, kuphatikiza "CTRL + H" imagwiritsidwa ntchito. Iwindo limawonekera momwe timadzaza minda. Mu mzere "What" lowetsani ",", mu mzere "What" - "". Minda ikadzazidwa, dinani "Bwezerani Zonse".

Pambuyo posintha izi m'mawu olowetsedwa, makoma onse adasinthidwa kukhala nyengo. Tsopano zatsala pang'ono kutengera zikhalidwe zomwe zasinthidwa uXNUMXbuXNUMXbain ndikuziyika patebulo lazolemba za Excel.

Kutsiliza

Nkhaniyi idawunikanso njira zothandiza komanso zodziwika bwino zosinthira zilembo za comma mu tizigawo ta decimal ndi madontho mu Excel spreadsheets. Nthawi zambiri, ogwiritsa ntchito amakonda chida cha Pezani ndi Kusintha m'malo kuti chikhale chowoneka bwino cha manambala, ndipo ntchito ya SUBSTITUTE imagwiritsidwa ntchito powerengera.