Formats masero muna Excel: dzinokosha pfungwa

Kana munhu asingadi kurangarira kana haazivi, MS Excel kushanda ndechimwe simba kupfuura zvishandiso kushanda kwete chete tabular data, asiwo arrays Database kuti akasika kana kutorwa. Muchiitiko chino, mumwe ukoshi anogona yayo functionality mupurogiramu. Format Masero ari Excel vakadaro kuti vanogona kuisa chero kukosha, nhamba kwete chete asiwo kubva muzana zvine musoro.

Formats masero muna Excel: Chii ichocho?

Chokutanga, ngatitarise chaipo chirongwa list, iyo kazhinji unonzi bhuku. It ane nhatu Pepa default kutoti zvimwe yakati. Achitaurazve pakati pedyo machira ari chinoitwa nekudzvanya pamusoro wayo rokuremekedza iri chinzvimbo kubhawa.

Asi date kupinda iri rakasiyana chii vakawanda vedu vakajaira kuona chete murugwaro mupepeti Shoko. In Excel, kuti default chakaita otomatiki kuziva date format. Zvisinei, hazvishamisi kuti dzimwe nguva kana kupinda rugwaro kana nhamba, kuti hurongwa anomuchinja kuti mashoko vamene dudziro yadzo.

Somuenzaniso, kupinda imwe nhamba urongwa, rinobatana kuitika musi. Vachanzi rwoga kutendeuka vose sero zvinogona muna Excel. Date kana pamusoro mamiriro ezvinhu akaratidza muchitokisi pakati mutsara wokutanga mbiru wokutanga. In mbiru pazasi musi rwoga achaparadzwa akazviisa kune zuva rimwe gare gare.

Kana pamanyorerwo yakaiswa kuti Numeric ukoshi, pano, zvakare, vane mazano avo pachavo. Somuenzaniso, grade nzvimbo, uye haagoni kuratidzwa. Typical tsika dziri Excel Spreadsheets chinoratidza chete integer. Mantissa rwunoratidzwa chete kana umbowo mazano pashure grade pfungwa. Muchiitiko chino, zviri vakagumisa. Saka, nokupinda Somuenzaniso, kukosha "Pi" (3.14) inodzidzisa apo paakaratidza grade pfungwa, uye rounding ona ramakanzi ukoshi 3.1. Kuratidza vatambi zvose kuti kuisa kuwanda iri separator kusarudza.

Interesting uye siyana maonero foni zvinogona muna Excel. Nguva apo kupinda anogona uwirirane uno, anopiwa kana yaunonyanya kushandisa pamwe Internet. Asi iwe unogona aongorore date ichi manually.

Formats masero muna Excel: chii kushandisa?

Matafura akasika Excel kana mune dzimwe purogiramu ipi yakafanana hachisi chinhu kuti chinotsigirwa zvirongwa vakawanda mirayiridzo iyi, asi zvinogona kuchinjwa kuva Database, kana kunyange chirongwa Codes. Mupfungwa, rinoreva Visual Basic mumanyoro. Chikuva wavo yakavakwa huru Microsoft Office pasuru. Uchifunga mubvunzo chii vanowanzova sero zvinogona muna Excel, unogona kusimbisa munhu mhando shoma inokosha chiyamuro date:

• Numeric;
• bvunzo;
• Musi uye nguva;
• exponential;
• zvemari uye mari;
• zvikamu zviduku;
• mubereko.

Panewo mutsetse yakawedzerwa zvinogona. Asi sezvo ari kutonga, kana kuti anoshandiswa chaizvo Kazhinji.

How kuchinja parameters muchitokisi?

Changing pamanyorerwo sero riri chinoitwa hwakawanda pamusoro rectangular muchitokisi. Iye anopupura chacho vanoshingaira hurumende, chechinyorwa Muterere nokusarurama-nekudzvanya apo runoenzanirana mutsara anosarudzwa. Uyezve, mumwe nomumwe mhando youduku inogona kuisa yokuwedzera ezvinhu. .. Somuenzaniso, kuratidza imwe nhamba grade nzvimbo, kuvapo imwe separator, mumwe pakunzi mari, etc. Mune mamwe zvinogona inogona kushandiswa uye zvimwe dzinonakidza zvinhu: kutanga paishandiswa code, nhamba dzenhare, kana kunyange vashandi nhamba kushandiswa Somuenzaniso, mu "1C" .

Sezvineiwo, sero zvinogona muna Excel «1C» anoona se yake, asi muna chinyorwa shanduro. Haufaniri kunyange kuita ekisipoti faira. Chaizvoizvo, mafaira hunogona kungoparara zvichishandurwa nevamwe zvirongwa, tichishanda Databases (akangofanana Access, Excel akavaka pamusoro mufananidzo). Uyezve, kana makasika faira akapa Links kana executable VB mumanyoro, mumwe Chirongwa anogona zvose achasvinudzwa uye kuponeswa kwaro yepakutanga chimiro.

mamwe kurongwa

No zvishoma kunakidza uye mamwe parameters chepurogiramu. Nokuti vakasununguka kushanda uye date kupinda, unogona kushandisa dzakasiyana-siyana pazviruva. Ivo kunyanya dzinosanganisira Tracking Links kune dzimwe machira, faira zvakabatanidzwa, kana kunyange zvinhu. Last akasika zvimwe mafomu uye vane yakakodzera zvinowanika kuti Excel «mhuri» haisi.

Kukurukura mapurogiramu mitauro

Kunze yekunwa mutauro Visual Basic, unogona kushandisa dzimwe nzira. Somuenzaniso, sero zvinogona muna Excel Delphi-zvakavapoteredza kungachinja nyore chaizvo. Zvisinei, dzimwe nguva vanhu vanonyora mapurogiramu kwakavakirwa mutauro uyu, panogona kuva nematambudziko. Zvechokwadi, vakawanda chete kuchinja kuti nhamba pamanyorerwo akashandisa tambo «exRange.NumberFormat: = '0.0';». A musimboti kwakadaro chete kusashanda pasi ezvinhu kuti masero ari fractional ndechokuti razero. Kana pane dzimwe nhamba iri chinyorwa format. Zvisinei, mubvunzo zvino haasi pamusoro paizvozvo. In izvi, iwe chete vanofanira kuchinja murayiro kana kushandisa zvakarurama nemarongerwo.

pachinzvimbo gumisiro

Sezvinogona kuoneka kubva apa, sero zvinogona muna Excel vari zvakasiyana-siyana. Sezvingatarisirwa, mune tsanangudzo pfupi kufunga zvose neimwe pamanyorerwo hazvitomboiti. Uyezve, kana isu funga kusikwa Masvomhu, charting, calculators kana dzishandise chero mamwe Masvomhu, zvichatora kutora nguva yakawanda.

Asi vose, chero aishandisa kupinda-pamwero kunyange pfupiso akadaro anogona kunzwisisa chii zvinogona vose saivo kuchinja uye zvinoenderana kukodzera zvaunoda. Asava mutendi mutsva vanoshandisa ndicharizivisa pakutanga ndizvo matambudziko. Zvisinei, kana uchidzidza zvose zvinokosha, ipapo dambudziko iri haungavhenekeri matambudziko.