Okuqukethwe
Uma ifomethi yombhalo yayisethelwe noma yimaphi amaseli eshidini (lokhu kungenziwa umsebenzisi noma uhlelo lapho kulayishwa idatha ku-Excel), izinombolo ezifakwe kamuva kulawa maseli i-Excel iqala ukubhekwa njengombhalo. Kwesinye isikhathi amaseli anjalo amakwe ngenkomba eluhlaza, okungenzeka ukuthi uyibonile:
Futhi ngezinye izikhathi inkomba enjalo ayiveli (okubi kakhulu).
Ngokuvamile, ukubonakala kwezinombolo-njengombhalo kudatha yakho ngokuvamile kuholela emiphumeleni eminingi engeyinhle kakhulu:
- ukuhlunga kuyeka ukusebenza ngokujwayelekile - "izinombolo-mbumbulu" ziyaminyana, futhi azihlelwa ngokulandelana njengoba kulindelekile:
- thayipha imisebenzi I-VLOOKUP (VLOOKUP) ungawatholi amanani adingekayo, ngoba kubo inombolo kanye nenombolo efanayo-njengombhalo kuhlukile:
- lapho kuhlungwa, izinombolo mbumbulu zikhethwa ngephutha
- eminye imisebenzi eminingi ye-Excel nayo iyeka ukusebenza kahle:
- njll
Kuyahlekisa ikakhulukazi ukuthi isifiso semvelo sokumane uguqule ifomethi yeseli ibe izinombolo akusizi. Labo. ukhetha amaseli ngokoqobo, chofoza kwesokudla kuwo, ukhethe Ifomethi yeseli (Fometha Amaseli), shintsha ifomethi ibe Izinombolo (inombolo), khama OK - futhi akukho okwenzekayo! Kube bonke!
Mhlawumbe, "lokhu akusona isiphazamisi, kodwa isici", kunjalo, kodwa lokhu akukwenzi kube lula kithi. Ngakho-ke ake sibheke izindlela ezimbalwa zokulungisa isimo - enye yazo izokusiza nakanjani.
Indlela 1. Ikhona lenkomba eluhlaza
Uma ubona ikhona lenkomba eliluhlaza kuseli elinenombolo ngefomethi yombhalo, bese uzibheka njengenhlanhla. Ungamane ukhethe wonke amaseli anedatha bese uchofoza isithonjana esiphuzi esizivelelayo esinophawu lwesibabazo, bese ukhetha umyalo. Guqulela kuNombolo (Guqula ube inombolo):
Zonke izinombolo ezisebangeni elikhethiwe zizoguqulwa zibe izinombolo ezigcwele.
Uma awekho nhlobo amakhona aluhlaza, bese uhlola ukuthi avaliwe yini kuzilungiselelo zakho ze-Excel (Ifayela - Izinketho - Amafomula - Izinombolo zifomethwe njengombhalo noma zandulelwe i-aphostrophe).
Indlela yesi-2: Faka kabusha
Uma engekho amaseli amaningi, ungashintsha ifomethi yawo ibe izinombolo, bese ufaka kabusha idatha ukuze ushintsho lwefomethi lusebenze. Indlela elula yokwenza lokhu ukuma kuseli bese ucindezela okhiye ngokulandelana F2 (faka imodi yokuhlela, iseli iqala ikhesa ecwayizayo) bese-ke Faka. Futhi esikhundleni F2 ungavele uchofoze kabili kuseli ngenkinobho yegundane engakwesokunxele.
Kuyaqondakala ukuthi uma kukhona amaseli amaningi, khona-ke le ndlela, yiqiniso, ngeke isebenze.
Indlela 3. Ifomula
Ungakwazi ukuguqula izinombolo-mbumbulu ngokushesha zibe kwezivamile uma wenza ikholomu eyengeziwe ngefomula eyisisekelo eduze kwedatha:
Ukususa kabili, kulokhu, kusho, eqinisweni, ukuphindaphinda ngo -1 kabili. Ukukhipha ngo-minus kuzonikeza ukuhlanganisa futhi inani kuseli ngeke lishintshe, kodwa lona kanye iqiniso lokwenza umsebenzi wezibalo lishintsha ifomethi yedatha ibe inombolo esiyidingayo.
Kunjalo, esikhundleni sokuphindaphinda ngo-1, ungasebenzisa noma yikuphi okunye ukusebenza kwezibalo okungenangozi: ukuhlukanisa ngo-1 noma ukwengeza nokukhipha uziro. Umphumela uzoba okufanayo.
Indlela 4: Namathisela Okukhethekile
Le ndlela yayisetshenziswa ezinguqulweni ezindala ze-Excel, lapho abaphathi besimanje abaphumelelayo bangena ngaphansi kwetafula lalingekho ikhona elibonisa okuluhlaza okwamanje ngokomthetho (livele ngo-2003 kuphela). I-algorithm yile:
- faka 1 kunoma iyiphi iseli engenalutho
- kopisha
- khetha amaseli anezinombolo ngefomethi yombhalo bese ushintsha ifomethi yawo ibe izinombolo (akukho lutho oluzokwenzeka)
- chofoza kwesokudla kumaseli anezinombolo-mbumbulu bese ukhetha umyalo Namathisela okukhethekile (Namathisela Okukhethekile) noma sebenzisa isinqamuleli sekhibhodi I-Ctrl + Alt + V
- efasiteleni elivulayo, khetha inketho Amanani (Amanani) и Hlanganisa (phindaphinda)
Eqinisweni, senza into efanayo nasendleleni yangaphambilini - ukuphindaphinda okuqukethwe kwamaseli ngeyodwa - kodwa hhayi ngamafomula, kodwa ngokuqondile kusuka ku-buffer.
Indlela 5. Umbhalo ngamakholomu
Uma ama-pseudonumbers azoguqulwa nawo abhalwe ngezihlukanisi zedesimali ezingalungile noma izihlukanisi eziyizinkulungwane, enye indlela ingasetshenziswa. Khetha ibanga lomthombo elinedatha bese uchofoza inkinobho Umbhalo ngamakholomu (Umbhalo kumakholomu) ithebhu Idatha (Usuku). Eqinisweni, leli thuluzi lenzelwe ukuhlukanisa umbhalo onamathelayo ube amakholomu, kodwa, kulokhu, siwusebenzisela inhloso ehlukile.
Yeqa izinyathelo ezimbili zokuqala ngokuchofoza inkinobho Olandelayo (Olandelayo), bese kweyesithathu, sebenzisa inkinobho Ukwengeza (Okuthuthukisiwe). Ibhokisi lengxoxo lizovuleka lapho ungasetha khona izinhlamvu zesihlukanisi ezitholakala manje embhalweni wethu:
Ngemuva kokuchofoza Qeda I-Excel izoguqula umbhalo wethu ube izinombolo ezijwayelekile.
Indlela 6. Macro
Uma kufanele wenze izinguquko ezinjalo kaningi, khona-ke kunengqondo ukwenza le nqubo ngokuzenzakalelayo nge-macro elula. Cindezela u-Alt+F11 noma uvule ithebhu Unjiniyela (Unjiniyela) Bese uqhafaza Visual Basic. Efasiteleni lomhleli elivelayo, engeza imojuli entsha ngemenyu Faka – Imojula bese ukopisha ikhodi elandelayo lapho:
I-Sub Convert_Text_to_Numbers() Selection.NumberFormat = "Okuvamile" Selection.Value = Selection.Value End Sub
Manje ngemva kokukhetha ububanzi, ungakwazi njalo ukuvula ithebhu Unjiniyela - Macros (Unjiniyela - Amamakhro), khetha i-macro yethu ohlwini, cindezela inkinobho Qalisa (Qalisa) - futhi ngokushesha uguqule izinombolo-mbumbulu zibe eziphelele.
Ungakwazi futhi ukwengeza le makhro ebhukwini lakho lomuntu siqu elikhulu ukuze uyisebenzise kamuva kunoma yiliphi ifayela.
PS
Indaba efanayo iyenzeka ngezinsuku. Amanye amadethi nawo angase abonwe yi-Excel njengombhalo, ngakho ukuqoqa nokuhlunga ngeke kusebenze. Izisombululo ziyafana nezezinombolo, ifomethi kuphela okufanele kushintshwe idethi-sikhathi esikhundleni senombolo.
- Ukwehlukanisa umbhalo onamathelayo ube amakholomu
- Izibalo ngaphandle kwamafomula ngokunamathisela okukhethekile
- Guqula umbhalo ube izinombolo ngesengezo se-PLEX