Maitiro ekugadzira yako wega data fomati muExcel

Iyo data fomati muMicrosoft Office Excel ndiyo mhando yekuratidzira kwemavara mumasero etafura array. Iyo purogiramu pachayo ine akawanda akajairwa mafomati sarudzo. Nekudaro, dzimwe nguva unofanirwa kugadzira chimiro chetsika. Nzira yekuita izvi ichakurukurwa munyaya ino.

Maitiro ekuchinja sero fomati muExcel

Usati watanga kugadzira yako fomati, unofanirwa kujairana nemisimboti yekuishandura. Iwe unogona kushandura imwe mhando yeruzivo inoratidzwa mumaseru etafura kuenda kune imwe zvichienderana neinotevera chirongwa:

1. Dzvanya bhatani rekuruboshwe rembeva pane inodiwa sero ine data kuti usarudze.
2. Tinya-kurudyi chero munzvimbo yakasarudzwa.
3. Mumenu yemukati, tinya pamutsara wekuti "Format Masero ...".
4. Muhwindo rinovhurwa, enda kuchikamu che "Nhamba" uye mu "Nhamba mafomati" block, sarudza imwe yezvakakodzera sarudzo nekudzvanya pairi kaviri neLMB.

5. Dzvanya "OK" pazasi pehwindo kuti ushandise chiito.

Teerera! Mushure mekushandura chimiro, nhamba dziri mumasero etafura dzicharatidzwa zvakasiyana.

Maitiro ekugadzira yako wega fomati muExcel

Nheyo yekuwedzera iyo yakajairwa data fomati muchirongwa chiri kutariswa inogona kukamurwa kuita matanho akati wandei:

1. Sarudza sero isina chinhu yepepa rekushanda uye, maererano nechirongwa chiri pamusoro, enda ku "Format Cells ..." hwindo.
2. Kuti ugadzire yako fomati, unofanirwa kunyora imwe seti yemakodhi mumutsara. Kuti uite izvi, sarudza chinhu "Yese mafomati" uye pahwindo rinotevera mundima ye "Type" isa yako fomati, uchiziva encoding yayo muExcel. Muchiitiko ichi, chikamu chimwe nechimwe chekodhi chinoparadzaniswa kubva kune chekare ne semicolon.

3. Tarisa kuti Microsoft Office Excel inoisa sei imwe fomati. Kuti uite izvi, sarudza chero encoding sarudzo kubva pane rondedzero inowanikwa pahwindo uye tinya "OK".
4. Iye zvino, muchitokisi chakasarudzwa, unofanira kuisa chero nhamba, semuenzaniso, imwe.

5. Nekufananidza, pinda musero fomati menyu uye tinya pashoko rekuti "Numeric" mune runyorwa rwemhando dzakaratidzwa. Iye zvino, kana ukaenda kuchikamu che "All formats" zvakare, ipapo iyo yakasarudzwa "Numeric" formatting inenge yatoratidzwa se encoding ine zvikamu zviviri: separator uye semicolon. Zvikamu zvicharatidzwa mundima ye "Type", neyekutanga inoratidzira nhamba yakanaka, uye yechipiri inoshandiswa kune zvakaipa.

6. Panguva ino, kana mushandisi atofunga musimboti wekodha, anogona kutanga kugadzira yake fomati. Nechinangwa ichi, anofanirwa kutanga avhara iyo Format Cells menyu.
7. Pane pepa rekushanda reExcel, gadzira iyo yekutanga tafura rondedzero inoratidzwa mumufananidzo uri pazasi. Tafura iyi inoonekwa semuenzaniso; mukuita, unogona kugadzira chero imwe ndiro.

8. Isa imwe column pakati pemaviri ekutanga.

Zvinokosha! Kuti ugadzire koramu isina chinhu, unofanirwa kudzvanya-kurudyi pane chero koramu yetafura array uye tinya pane "Isa" mutsara muhwindo remukati.

9. Mukoramu yakagadzirwa nemaoko kubva kuPC keyboard, iwe unofanirwa kuisa iyo data kubva pakona yekutanga yetafura.

10. Sarudza iyo yakawedzera koramu uye tinya-kurudyi pairi. Enda kune iyo cell fomati hwindo zvinoenderana nechirongwa chakurukurwa pamusoro.
11. Enda kune "All formats" tab. Pakutanga, izwi rekuti "Main" richanyorwa mumutsara we "Type". Ichada kutsiviwa nekukosha kwayo.
12. Nzvimbo yekutanga mukodhi yefomati inofanirwa kuve yakakosha kukosha. Pano tinonyora izwi rekuti ""Not negative". Mazwi ese anofanirwa kuvharirwa mumakotesheni.
13. Mushure mekukosha kwekutanga, isa semicolon uye nyora ""kwete zero".
14. Zvakare tinoisa semicolon uye nyora musanganiswa "" pasina hyphen "".
15. Pakutanga kwemutsara, iwe uchadawo kunyora "Akaunti Nha.", uye wobva waisa yako fomati, semuenzaniso, "00-000 ″".

16. Sevha shanduko nekudzvanya pakanzi "Zvakanaka" pazasi pehwindo uye wedzera koramu yakawedzerwa kuti uone kukosha chaiko pachinzvimbo chemavara "####". Mitsara kubva mufomati yakagadzirwa ichanyorwa ipapo.

Mamwe Mashoko! Kana ruzivo rwuri mumasero rusina kuratidzwa, ipapo mushandisi akakanganisa paakagadzira yavo fomati. Kuti ugadzirise mamiriro acho ezvinhu, iwe unozofanirwa kudzokera kune iyo tabular array element yekufometa zvigadziriso hwindo uye tarisa kurongeka kweiyo yakapinda data.

Maitiro ekubvisa isingadiwe data fomati muMicrosoft Office Excel

Kana munhu asingadi kushandisa imwe kana imwe yakajairwa chirongwa chefomati, anogona kuibvisa kubva pane rondedzero yehukoshi. Kuti uite basa racho munguva ipfupi inobvira, unogona kushandisa inotevera algorithm:

1. Dzvanya nebhatani rekuruboshwe rembeva pane chero sero yetafura array. Unogona kungodzvanya pane chinhu chisina chinhu chepepa rekushanda.
2. Muchikamu chemhando yebhokisi, tinya pane "Format Masero" mutsara.
3. Enda kuchikamu che "Nhamba" mubharu repamusoro remenu inovhura.
4. Sarudza chimiro chenhamba chakakodzera kubva pamabhokisi ari kuruboshwe uye sarudza nekudzvanya LMB.
5. Dzvanya bhatani re "Delete", iro riri mukona yezasi yekona ye "Format Cells" hwindo.
6. Bvumirana neyambiro yehurongwa uye tinya OK kuvhara hwindo. Iyo yakasarudzwa yakajairwa kana tsika fomati inofanirwa kudzimwa kubva kuMS Excel pasina mukana wekupora mune ramangwana.

mhedziso

Saka, kuwedzera mafomati akajairwa kuMicrosoft Office Excel inzira yakapusa yaunogona kubata wega. Kuti uchengetedze nguva uye kurerutsa basa, zvinokurudzirwa kushandisa mirairo iri pamusoro.