Thola inguqulo ye-DirectX ku-Windows 10

Abasebenzisi abaningi be-Excel babhekene nombuzo wokufaka isikhathi sokungena esikhundleni samakhomitha etafuleni. Lokhu kuvame ukuthi ngenxa yokuthi emazweni akhuluma isiNgisi kuwumkhuba ukuhlukanisa izingxenyana zamadayimenti kusuka kunani eligcwele ichashazi, futhi sinomhlahlandlela. Okubi nakakhulu, izinombolo ezinephashazi azibonakali ngezilimi zesiRussia izinguqulo ze-Excel njengefomethi yenombolo. Ngakho-ke, lesi siqondiso esithile sokufaka esikhundleni siyasebenza. Ake sibone ukuthi singashintsha kanjani amaphuzu ama-commas ku-Microsoft Excel ngezindlela ezihlukahlukene.

Izindlela zokushintsha iphuzu ku-comma

Kunezindlela eziningana eziqinisekisiwe zokushintsha iphuzu ku-comma ohlelweni lwe-Excel. Ezinye zazo zixazululwa ngokuphelele ngosizo lokusebenza lolu hlelo lokusebenza, futhi ukusetshenziswa kwabanye kudinga ukusetshenziswa kwezinhlelo zangaphandle.

Indlela 1: Thola futhi Ubeke Ithuluzi

Indlela elula yokufaka amachashazi ngama-commas ukusizakala ngamathuba anikezwe ithuluzi. "Thola futhi ushintshe". Kodwa, futhi naye kudingeka uziphatha ngokucophelela. Ngemuva kwalokho, uma isetshenziswe ngokungalungile, wonke amaphuzu eshidi azoshintshwa, ngisho nakulezo zindawo lapho zidinga ngempela, isibonelo, ezinsukwini. Ngakho-ke, le ndlela kufanele isetshenziswe ngokucophelela.

  1. Ukuba ngaphakathi kuthebhu "Ikhaya"eqenjini lamathuluzi Ukuhlela kwi-tape chofoza inkinobho "Thola futhi uqokomise". Emenyu ebonakalayo, chofoza ku-intwana "Faka esikhundleni".

  2. Iwindi ivula "Thola futhi ushintshe". Ensimini "Thola" faka uphawu olucacile (.). Ensimini "Faka esikhundleni" - uphawu lwe-comma (,). Chofoza inkinobho "Izinketho".

  3. Vula usesho olwengeziwe bese ubeka izilungiselelo esikhundleni. Ipharamitha ehlukile "Faka esikhundleni ..." chofoza inkinobho "Fometha".

  4. Ifasitela ivuleka lapho singakwazi khona ukubeka ngokushesha ifomula ukuthi ishintshwe, kungakhathaliseki ukuthi kungenzeka yini ngaphambili. Esikhathini sethu, into esemqoka ukusetha ifomethi yedatha yenombolo. Kuthebhu "Inombolo" phakathi kwamaqoqo ezinombolo zezinombolo ukhethe into "Numeric". Sicindezela inkinobho "Kulungile".

  5. Ngemva kokubuyela ewindini "Thola futhi ushintshe", ukhethe lonke uhla lwamaseli eshidi, lapho udinga ukwenza iphuzu lokufaka esikhundleni ngomsindo. Lokhu kubaluleke kakhulu, ngoba uma ungayikhethi ibanga, khona-ke ukushintshwa kuyokwenzeka phezu kwephepha lonke, okuyinto engadingeki ngaso sonke isikhathi. Bese uchofoza inkinobho "Faka konke".

Njengoba ubona, ukushintshwa kuphumelele.

Isifundo: ukushintsha izinhlamvu ku-Excel

Indlela 2: Sebenzisa umsebenzi we-SUB

Enye indlela yokushintsha iphuzu nge-comma ukusebenzisa uhlelo FIT. Noma kunjalo, uma usebenzisa lo msebenzi, ukushintshwa akuveli emangqamuzaneni omthombo, kodwa kuboniswa kukholomu ehlukile.

  1. Khetha iseli ezoba ngowokuqala kukholomu ukubonisa idatha eshintshiwe. Chofoza inkinobho "Faka umsebenzi"okuyinto ingakwesokunxele kwendawo yocingo lomsebenzi.

  2. Iqala umsebenzi wizard. Kulolu hlu olwethulwe efasiteleni evulekile, sibheke umsebenzi THOLA. Khetha bese uchofoza inkinobho. "Kulungile".

  3. Iwindi lempikiswano yokusebenza ivuliwe. Ensimini "Umbhalo" udinga ukufaka izixhumanisi zeselula yokuqala yekholomu lapho izinombolo ezinamachashazi zikhona. Lokhu kungenziwa ngokumane ngokukhetha le seli eshimbeni ngegundane. Ensimini "I-star_text" faka iphuzu (.). Ensimini "I-new_text" faka umbala (,). Inkambu "Inombolo Yokungena" Asikho isidingo sokugcwalisa. Umsebenzi ngokwawo uyoba nephethini elilandelayo: "= SUB (ikheli leseli;". ";", ",") ". Sicindezela inkinobho "Kulungile".

  4. Njengoba ungabona, esitokisini esisha, inamba kakade inombhalo esikhundleni sephuzu. Manje kudingeka senze umsebenzi ofanayo kuwo wonke amanye amaseli kukholomu. Yiqiniso, awudingi ukufaka umsebenzi ngenombolo ngayinye; kunendlela engcono kakhulu yokwenza ukuguqulwa. Sifika engxenyeni engezansi ephansi yeseli equkethe idatha eguquliwe. Uphawu lokugcwalisa luvela. Ukubamba inkinobho yegundane lesokunxele, donsela phansi emngceleni ophansi wendawo equkethe idatha ezoguqulwa.

  5. Manje sidinga ukwabela amaseli ifomethi yenombolo. Khetha yonke indawo yedatha eguquliwe. Ithebhu yethebhu "Ikhaya" efuna ibhokisi lamathuluzi "Inombolo". Kuhlu lokudonsa phansi, sishintsha ifomethi kuzinombolo.

Lokhu kugcwalisa ukuguqulwa kwedatha.

Indlela 3: Sebenzisa i-Macro

Ungaphinda ubeke isikhathi senkomfa nge-comma ku-Excel ngokusebenzisa i-macro.

  1. Okokuqala, udinga ukunika amandla i-macros nethebhu "Unjiniyela"uma zingabalwa.

  2. Iya kuthebhu "Unjiniyela".

  3. Sicindezela inkinobho "Visual Basic".

  4. Faka ikhodi elandelayo efasiteleni lomhleli:

    I-sub-macro_substitution_complete ()
    Ukukhethwa.Shintsha lokho: = ".", Ukufaka esikhundleni: = ","
    Qedela ngaphansi

    Vala umhleli.

  5. Khetha indawo yamaseli eshidi ofuna ukuguqula. Kuthebhu "Unjiniyela" cindezela inkinobho Macros.

  6. Ewindini evula, uhlu lwamacros. Khetha ohlwini "I-Macro ithatha isikhundla sezinkampani". Sicindezela inkinobho Qalisa.

Emva kwalokho, amaphuzu ashintshwe kuma-commas ebangeni elikhethiwe lamaseli.

Qaphela! Sebenzisa le ndlela ngokucophelela. Imiphumela yale macro ayinakuguqulwa, ngakho-ke khetha kuphela lawo maseli ofuna ukuyisebenzisa.

Isifundo: kanjani ukudala i-macro ku-Microsoft Excel

Indlela 4: Sebenzisa i-Notepad

Indlela elandelayo ihilela ukukopisha idatha kumhleli wombhalo ojwayelekile we-Windows Notepad, nokuyishintsha kule hlelo.

  1. Khetha ku-Excel indawo yamaseli ofuna ukufaka esikhundleni sephoyinti nge-comma. Chofoza inkinobho yesokudla yegundane. Kumenyu yesimo, khetha into "Kopisha".

  2. Vula i-Notepad. Cindezela inkinobho yegundane lesokudla, futhi ohlwini olubonakala luchofoza entweni Namathisela.

  3. Chofoza kwimenyu yemenyu Hlela. Ohlu oluvela, khetha into "Faka esikhundleni". Ngaphandle kwalokho, ungamane uthayiphe inhlanganisela eyinhloko ekhibhodi Ctrl + H.

  4. Ukusesha nokushintsha iwindi kuvulwa. Ensimini "Yini" ukuphelisa. Ensimini "Yini" - i-comma. Sicindezela inkinobho "Faka konke".

  5. Khetha idatha eguquliwe ku-Notepad. Chofoza inkinobho yesokudla yegundane, futhi ohlwini khetha into "Kopisha". Noma chofoza isinqamuleli sekhibhodi Ctrl + C.

  6. Siphindela ku-Excel. Khetha ububanzi bamaseli lapho kufanele kube khona amanani. Sichofoza kuso nge inkinobho efanele. Emenyu ebonakala esigabeni "Izinketho zokufaka" chofoza inkinobho "Gcina umbhalo kuphela". Noma, cindezela inhlanganisela yokhiye Ctrl + V.

  7. Kulo lonke uhla lwamaseli, setha ifomethi yenombolo ngendlela efanayo nangaphambili.

Indlela 5: Shintsha izilungiselelo ze-Excel

Njengenye yezindlela zokuguqula amaphuzu kuma-commas, ungasebenzisa izilungiselelo zokwenza ngokwezifiso ze-Excel.

  1. Iya kuthebhu "Ifayela".

  2. Khetha isigaba "Izinketho".

  3. Iya endaweni "Okuthuthukisiwe".

  4. Esigabeni sesethingi "Izinketho zokuhlela" ungahloli into "Sebenzisa ama-delimiters wesistimu". Ensimini esebenzayo "Umhlukanisi wengxenye yonke kanye nengxenye" ukuphelisa. Sicindezela inkinobho "Kulungile".

  5. Kodwa, idatha ngokwayo ngeke ishintshe. Sizikopisha ku-Notepad, bese uzihlanganisa endaweni efanayo ngendlela evamile.

  6. Ngemuva kokusebenza kuqedile, kunconywa ukubuyisela izilungiselelo ezizenzakalelayo ze-Excel.

Indlela 6: shintsha izilungiselelo zesistimu

Le ndlela ifana neyaphambilini. Kuphela lesi sikhathi, asiguquli izilungiselelo ze-Excel. Futhi izilungiselelo zesistimu yeWindows.

  1. Ngemenyu "Qala" singena "Iphaneli Yokulawula".

  2. Ku-Panel Yokulawula, iya esigabeni "Iwashi, ulimi nesifunda".

  3. Yiya esigatshaneni "Amazinga Olimi Nezifunda".

  4. Ewindini evuliwe kuthebhu "Amafomethi" cindezela inkinobho "Izilungiselelo ezithuthukile".

  5. Ensimini "Umhlukanisi wengxenye yonke kanye nengxenye" sishintsha umbala ngephuzu. Sicindezela inkinobho "Kulungile".

  6. Kopisha idatha ngokusebenzisa i-Notepad ku-Excel.

  7. Sibuyisela izilungiselelo ze-Windows ezedlule.

Iphuzu lokugcina kubaluleke kakhulu. Uma ungayisebenzisi, ngeke ukwazi ukwenza imisebenzi evamile ye-arithmetic nedatha eguquliwe. Ngaphezu kwalokho, ezinye izinhlelo ezifakwe kwikhompyutha zingasebenza futhi ngokungalungile.

Njengoba ungabona, kunezindlela eziningana zokufaka esikhundleni sokuma okugcwele nge-comma ku-Microsoft Excel. Yiqiniso, abasebenzisi abaningi bakhetha ukusebenzisa ithuluzi elilula futhi elilula kakhulu le nqubo. "Thola futhi ushintshe". Kodwa, ngeshwa, kwezinye izimo ngoncedo lwazo akunakwenzeka ukuguqula idatha ngendlela efanele. Ngaleso sikhathi lapho ezinye izixazululo zingabasiza.

Okuthunyelwe Popular

https://termotools.com zu.termotools.com © Windows 2024