Shandura poindi kune decimal point muExcel

Excel chishandiso chakakosha kune chero nyanzvi inoshanda nenhamba uye data. Nekudaro, dzimwe nguva tinopinda muchipinganidzo chidiki: mutsauko uripo pakati pekushandisa nhambo kana koma kupatsanura decimals. Zvichienderana nenzvimbo yako kana zvaunoda iwe pachako, ungangoda kushandura chiparadzanisa mumaspredishiti ako. Muchidzidzo ichi, tichakutungamira nhanho nhanho kuti iwe ugone kuita shanduko iyi nyore uye zvinobudirira.

Usati watanga, zvakakosha kuratidza kuti Excel inokutendera kuti ushande neaviri poindi senge nedesimali point, asi kwete panguva imwe chete. Kana spreadsheet yako ikaiswa kuti ishandise koma, hauzokwanisi kushandisa nguva, neimwe nzira. Izvi zvinogona kukonzeresa zvikanganiso paunenge uchigadzira mafomula kana magirafu kana iwe ukangoerekana waisa chiratidzo chisiri icho. Pamusoro pezvo, kana uchiunza maspredishiti kubva kune mamwe masosi, unogona kusangana neakasiyana decimal separator pane yaunoda.

Maitiro ekushandura poindi kusvika kune decimal point muExcel

Kuti uite shanduko iyi, zvinokurudzirwa kushandisa shanduro yakabhadharwa yeExcel, zvichida gare gare kupfuura Excel 2000. Kutanga neExcel 2007, purogiramu yepurogiramu yakagadziridzwa zvakakwana, saka mirayiridzo inogona kusiyana zvishoma mumashanduro apfuura.

Usati wagadzirisa spreadsheet yako, zvakakosha kuti ita kopi yekuchengetedza yedata rako. Iwe unogona kushandisa ekunze hard drive kana Cloud kuchengetedza masevhisi kuve nechokwadi chekuti une yakachengeteka vhezheni yebasa rako kana paine zviitiko zvisingafanoonekwi.

Tarisa chipatsanuri chedesimali chazvino

Kuti utarise kuti ndeupi mutsara wedesimali shanduro yako yeExcel iri kushandisa, tevera matanho aya:

1. Tinya-kurudyi cell isina chinhu.
2. Sarudza "Cell Format" sarudzo.
3. Mu "Nhamba" tab, sarudza chikamu che "Nhamba".
4. Pano unogona kuona default nhamba yedesimalis uye kana vhezheni yako yeExcel ichishandisa koma kana mapoinzi.

Shandura patsanuri yedesimali

Kana uchinge waona yazvino decimal separator, yave nguva yekuichinja. Tevera mirairo iyi:

1. Enda ku "Faira" menyu uye sarudza "Options." Mune shanduro dzekare dzeExcel, iyo "Sarudzo" sarudzo iri mu "Zvishandiso" menyu.
2. Svika chikamu che "Advanced".
3. Tarisa chikamu che "Decimal Separator".
4. Mubhokisi rinoenderana, shandura poindi kuenda kudecimal point, kana zvinopesana, maererano nezvido zvenyu.
5. Dzvanya "OK" kuchengetedza shanduko.

Excel inozoisa otomatiki kupatsanurwa kwedesimali kumaseru ese ane nhamba dzedesimali muspredishiti rako.

Zvakanakira kushandisa iyo chaiyo decimal separator

Kushandisa iyo chaiyo decimal separator mune yako Excel spreadsheets ine akati wandei mabhenefiti:

• Dzivisa kukanganisa mumafomula uye magirafu nekukanganisa kuisa chiratidzo chisiricho.
• Inotungamira kuenderana nemamwe mapurogiramu kana masisitimu izvo zvingada chaiyo decimal separator.
• Inobvumira kuverenga kwakajeka uye kunoenderana kwenhamba dzedesimali, kunyanya kana iwe uchigovera maspredishiti ako nevamwe vanhu.

Pamusoro pezvo, kana uchipinza data kubva kune mamwe masosi, kuve nechokwadi chekuti une yakakodzera decimal separator kuchakuchengetera nguva uye kushanda nesimba kuongorora nekugadzirisa manhamba.

Gadzirisa data rako muExcel nekuchinja kune decimal mapoinzi

Izvo zvakakosha kuti uzive kuti kuchinja decimal separator muExcel hakuzokanganisa nhamba dzawakatoisa muspredishiti rako. Kana iwe uchida kugadzirisa iripo decimals, iwe uchafanirwa kuzviita nemaoko kana kushandisa a kutsiva formula.

Zvakare, ramba uchifunga kuti shanduko iyi ichashanda kune ese maspredishiti matsva aunogadzira muExcel. Kana iwe uchida kushandisa yakasarudzika decimal separator mune yakasarudzika purojekiti, iwe unozofanirwa kuigadzirisa zvakare mumasarudzo echirongwa.

Kuchinja nguva kusvika padanho redesimali muExcel inzira yakapusa asi yakakosha kuchengetedza kuwirirana uye kudzivirira zvikanganiso mumaspredishiti ako. Nekutevera matanho anotsanangurwa muchidzidzo chino, unozogona kuchinjisa Excel kune zvaunoda uye zvaunofarira, uye kushanda nemazvo nenhamba dzedesimali. Usakanganwa kuchengetedza data rako usati waita chero shanduko, uye unakirwe nekuchinjika kunopihwa neichi chine simba chekuverenga chishandiso.