Indlela yokususa ii-commas kunye nama-hyperlink kumanani kwi-Excel

Amaninzi amaninzi xa ukukopisha idatha kwi-intanethi ku-Excel, amanani anama-commas njengabahluli bamawaka. Kanye njengoko sitshintsha ifomathi yefowuni ukuba inombhalo, isabhaliweyo kuba i-Excel ayikwazi ukuqonda i-separator yamawaka emva kwenani linamadijithali e-6, oko kukuthi, ngaphezu kwesigidi esinye.

Ndiza kukubonisa imeko yetafile yee-intanethi, apho Ndathetha iintsuku ezimbalwa ezedlulileyo:

estadisticasinternet Bona indlela ikopi / unamathisela osebenzayo, ngokungakhathaliseki ukuba ayithumeli iiseli ezidibeneyo. Kodwa ezo manani zihamba njengemibhalo.

estadisticasinternet4

Ukuphuma kwabo kuthatha amanyathelo amathathu alula:

izibalo ze-intanethi 1 Nika iiseli ifomathi yombhalo.

Oku kwenziwa ngokukhetha umbhalo, ngokuchofoza ngokuchanekileyo nokukhetha Ifom yeeseli. Emva koko senza utshintsho.

2 Khangela uphinde uthumele iifowuni.

Oku kusebenze ngocwangciso lwe Ctrl + b xa kwenzeka kwi-Excel ngeSpanish. Khetha okukhethwa kukho ukufumana i-comma (,) kwaye ungenanto ebhokisini yendawo. Emva koko iqhosha Hlaziya konke.

Isiphumo kukuba zonke ii-commas ziya kususwa. Qaphela, kuba ukhetho kufuneka lufake kuphela amanani enqwenela ukutshintsha ukuze angonakali iinxalenye zefayili apho kukho ii-commas ezivumelekileyo.

3 Nika iiseli ifomathi yenombolo.

Emva koko i-1 inokuphindaphindiweyo, kodwa ibonisa ukuba ifomathi yinombolo.

Indlela yokususa ii-hyperlink kwiiseli ezininzi

Ngokuqinisekileyo oku kukho enye indlela kodwa ndiyayikhulula kuba iphezu lolwimi kwisenzo esifanayo. Ukususa enye ngenye ingxaki kuba kwenziwe iqhosha elifanelekileyo lemouse, kodwa ukwenza kwiseli eziliqela akunakwenziwa okanye ikopishwe kwaye idlwengulwe okhethekileyo, ngoko xa sibuza unamathisele imilinganiselo i-hyperlink iza kuhlala ihamba ngenxa yokuba ifakwe kwiseli njenge xml kwaye ingekho kwisicatshulwa.

Yintoni enokuyenza ukukopisha yonke into esithandayo, kwikholamu engenanto kunye nenketho ekhethiweyo ekhethekileyo, ukunamathisela izixhumanisi.

Ezi iiseli ziza kuba nomxholo kodwa zingekho i hyperlink kwaye ezi ziyakopizwa kwaye zifakwe kwiixabiso ukuya kwiiseli zangaphambili.

Iimpendulo ze-5 "Indlela yokukhipha ii-commas kunye nama-hyperlink kumanani kwi-Excel"

  1. Kundikhonze kakhulu enkosi. Ayifani nazo zonke i-YouTube geeks

  2. Molo Ndidinga ukuphelisa i-comma ngokugcina i-0 ekupheleni kwedesimali, kodwa xa ndisebenzisa inkqubo efundisiweyo iyasuswa. I-2.950,30 ehlala i-295030. Ndisebenzisa eyiphi ifomathi? Okanye ndisebenzisa yiphi inkqubo? Enkosi !!

  3. Oku kwenzeka kuwe kuba esikhundleni sokushiya indawo ecocekileyo, apho ukhetha ukuba kutheni ukuba i-comma izotshintshwa, ubeka isikhala kunye nebhayibha yendawo kwikhibhodi.
    Ngoku kufuneka ukhethe isikhala esingentla naphantsi kwakho usiye sihlambuluke, kwaye siya kusula izikhala.

  4. I-ps ikhangele kwaye ndenze amanyathelo abe ne-1,080,480 kwaye ndihlala 1 080 480 kwaye ndifuna i-1080480, yintoni endiyenzayo?

Shiya impendulo

Idilesi yakho ye email aziyi kupapashwa.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.