Maitiro ekushandura maratidziro eExcel manhamba asina kunaka
Microsoft Excel inoratidza manhamba asina kunaka ane inotungamira minus sign by default. Itsika yakanaka kuita kuti nhamba dzisina kunaka dzive nyore kuziva, uye kana usiri kufara neiyo default set, Excel inopa mashoma akasiyana sarudzo yekufometa nhamba dzisina kunaka.
Excel inopa maviri akavakirwa-mukati nzira dzekuratidza nhamba dzisina kunaka, uye iwe unogona zvakare kuseta tsika fomati. Ngatinyure mukati.
Shandura kune imwe yakavakirwa-mukati isina kunaka nhamba sarudzo
Chinhu chimwe chekucherechedza apa ndechekuti Excel icharatidza akasiyana akavakirwa-mukati sarudzo zvichienderana nenzvimbo yako yekushandisa uye marongero emitauro.
Kune avo vari muUnited States, Excel inopa anotevera akavakirwa-mukati sarudzo dzekuratidzira nhamba dzisina kunaka:
- Mutema nechiratidzo chekubvisa
- mutsvuku
- mabhuraketi (unogona kusarudza tsvuku kana dema)
MuUK nedzimwe nyika zhinji dzemuEurope, kazhinji unozokwanisa kuseta manhamba asina kunaka kuti aoneke mutema kana tsvuku aine kana asina minus sign (mumavara ese ari maviri) asi iwe hauna sarudzo yezvibodzwa. Unogona kudzidza zvakawanda nezvezvirongwa zvedunhu izvi pa Microsoft webhusaiti .
Hazvinei kuti uripi, unokwanisa kuwedzera dzimwe sarudzo nekugadzirisa mafomati enhamba, yatichavhara muchikamu chinotevera.
Kuti uchinje kune imwe yakavakirwa-mukati fomati, tinya-kurudyi pane sero (kana huwandu hwemasero akasarudzwa) uye tinya iyo Format Cells kuraira. Iwe unogona zvakare kudzvanya Ctrl + 1.
Mufafitera reMafomati Masero, chinja kuNhamba tab. Kuruboshwe, sarudza "Nhamba" chikamu. Kurudyi, sarudza imwe sarudzo kubva paNegative Numbers list wobva wadzvanya OK.
Ziva kuti mufananidzo uri pazasi unoratidza sarudzo dzaunoona muUS. Tichataura nezve kugadzira yako yega marongero muchikamu chinotevera, saka hazvina dambudziko kana zvaunoda zvikasaratidza.
Pano, isu takasarudza kuratidza maitiro asina kunaka mutsvuku ane maparentheses.
Maonero aya anosarudzika zvakanyanya pane default Excel.
Gadzira fomati yenhamba isina kunaka
Iwe unogona zvakare kugadzira yako nhamba mafomati muExcel. Izvi zvinokupa iwe kutonga kwakazara pamusoro pekuti iyo data inoratidzwa sei.
Tanga nekudzvanya-kurudyi pane sero (kana huwandu hwemasero akasarudzwa) wobva wadzvanya iyo Format Cells command. Iwe unogona zvakare kudzvanya Ctrl + 1.
PaNhamba tab, sarudza iyo Tsika chikamu kuruboshwe.
Iwe uchaona runyoro rweakasiyana mafomati kurudyi. Izvi zvingaita sezvinovhiringa pakutanga asi hapana chikonzero chekutya.
Chimiro chega chega chakakamurwa kuita zvikamu zvina, chikamu chimwe nechimwe chakaparadzaniswa nesemicolon.
Chikamu chekutanga ndechezvakakosha, chechipiri ndechezvakashata, chechitatu che zero values, uye chikamu chekupedzisira chemavara. Haufanire kunge uine ese mapartitions akafomatidzwa.
Semuenzaniso, ngatigadzirei fomati yenhamba isina kunaka inosanganisira zvese zvinotevera.
- mublue
- pakati pemabhureki
- Hapana nzvimbo dzedesimali
MuType box, isa kodhi iri pazasi.
#, ## 0; [Blue] (#, ##0)
Chiratidzo chega chega chine zvachinoreva, uye muchimiro ichi, # inomiririra kuratidzwa kwenhamba yakakosha, uye 0 chiratidzo chenhamba isina kukosha. Iyi nhamba isina kunaka iri mumaparenthes uye inoratidzwawo neblue. Kune makumi mashanu nenomwe mavara akasiyana aunogona kudoma nezita kana nhamba mune yakasarudzika nhamba fomati base. Yeuka kuti semicolon inoparadzanisa kuratidzwa kwenhamba yakanaka uye yakaipa.
Heino mhinduro yedu:
Tsika mafomati hunyanzvi hunobatsira muExcel. Iwe unogona kugadzira fomati inodarika yakajairwa marongero anowanikwa muExcel angave asina kukwana pane zvaunoda. Kugadzira nhamba dzisina kunaka ndechimwe chezvinhu zvinonyanya kushandiswa pachishandiswa ichi.
