Maitiro ekushandisa iyo Accounting Nhamba Fomati muMicrosoft Excel
Kana ukashandisa Microsoft Excel kuitira accounting, ungangoda kushandisa iyo accounting nhamba fomati yenhamba dzako. Pane nzira dzakawanda dzekushandisa izvi kubatana Uye isu tichatsanangura sei.
Ndeipi iyo accounting nhamba fomati?
Pakutanga kuona, iyo accounting nhamba fomati inoita seyemari fomati. Zvisinei, pane zvimwe zvakasiyana pakati pezviviri izvi.
Misiyano iyi ndeiyi:
- chiratidzo chemari : Iyo accounting nhamba fomati inoisa chiratidzo chemari kuruboshwe kuruboshwe kwesero.
- Zero Semadheshi: Mazero ako anoratidzwa semadheshi mune iyi nhamba fomati.
- Negatives mumaparentheses : inoratidzwa Nhamba dzisina kunaka
()pakati pemabhureki. Excel haiite izvi nekukasira.
Idzi dzese nzira dziri pazasi dzinokutendera kuti uise iyo yakafanana nhamba yeakaunzi fomati kunhamba dzako, saka shandisa chero nzira yaunoona iri nyore kuita.
Isa accounting nhamba fomati ine ribhoni sarudzo
Excel ine sarudzo mubhabhoni yayo yekukubatsira nekukurumidza kushandisa iyo accounting nhamba fomati mumaspredishiti ako.
Kuti uishandise, tanga wavhura spreadsheet neMicrosoft Excel. Muspredishiti, sarudza maseru ane nhamba dzaunoda kushandura kuita manhamba eakaunzi.
في Excel bar kumusoro Dzvanya paKumba tab.
PaKumba tebhu, muchikamu cheNhamba, tinya pasi museve icon padivi peiyo Accounting Nhamba Format sarudzo.
Mumenu inovhurwa, sarudza mari yenhamba dzako.
Uye nhamba dzako dzakasarudzwa ikozvino shandisa iyo accounting nhamba fomati.
Magadzirira.
Isa iyo accounting nhamba fomati kuburikidza neinodonha menyu
Imwe nzira yekushandisa iyo accounting nhamba fomati ndeye kushandisa iyo nhamba yefomati yekudonha-pasi runyoro.
Kuti ushandise nzira iyi, vhura spreadsheet neMicrosoft Excel. Zvadaro sarudza masero ane nhamba mukati.
MuExcel ribhoni kumusoro, tinya iyo Kumba tebhu.
PaKumba tebhu, muchikamu cheNhamba, tinya pane yekudonha-pasi menyu.
Kubva pane inodonha menyu, sarudza Accounting.
Nhamba dzese dzawakasarudza dzave muaccounting nhamba fomati.
Ichi chi.
Shandisa nhamba dzeakaunzi nehwindo reFormat Cells
Nzira yechitatu yekushandisa iyo accounting nhamba fomati muExcel ndeyekuvhura iyo Format Cells hwindo.
Kuti uite izvi, vhura spreadsheet uye sarudza maseru ane manhamba mairi. Dzvanya kurudyi imwe yemasero aya uye sarudza Format Cells kubva kumenyu.
Hwindo reFormat Cells richavhurwa. Pano, kubva kuChikamu menyu kuruboshwe, sarudza Accounting.
muchikamu chakanaka, Sarudza mapoinzi edesimali enhamba dzako Kushandisa "decimal nzvimbo" sarudzo. zvino Sarudza mari Kubva pane "Symbol" yekudonha-pasi menyu.
Pakupedzisira, tinya OK pazasi pehwindo.
Masero awakasarudza iye zvino akaumbwa mufomati yenhamba dzeakaunzi.
Iwe ikozvino wakagadzirira mabasa ako e accounting mune yako Excel spreadsheets.
Ko Excel inobvisa zero kubva pakutanga kwenhamba dzako? Pane nzira Kuti achengete mazero aya .
