Excel Decimal Format Options

Shandura Nhamba Yematunhu Akakosha Anoratidzwa Ne Data

Excel inokubvumira kudzora nhamba yezvimbo dzepamusoro dzakaratidzwa nedata.

Zvisarudzo zvekuratidzira zvipimo zvinosanganisira

• kushandura dhiyabhorosi iripo iko kushandisa ribhoni
• kugadzika nhamba yezvimbo dzepamusoro dze data iripo kana kuti masero asina chinhu anoshandisa Format Cells dialog box
• Kurongedza nhamba dzisina kuenzana dzezvimbo dzepamusoro dzakaratidzwa mumasero ose mune pepa rekushanda

Mumwe nomumwe kana mapoka emasero pane kuti ave nemashoko akapararira pane masero akawanda mumushandi webasa .

Nokuwanda kwenhamba dzakatopinda mune pepa rekushanda, unogona kuwedzera kana kuderedza nhamba yezvivako zvinoratidzwa mushure mekupedzisira kwekushandisa kuburikidza nekushandisa bhatani rekushandisa. Iwe unogonawo kutsanangura nhamba yezvimbo dzekusimudza dzaunoda kushandisa kana ukashandisa yakavakwa-nhamba yemafaira kumasero kana data. Kuti uve neExcel pinda mapeji ekupedzisira kwauri, unogona kutsanangura imwe yakagadziridzwa yepeji yenhamba.

Sarudza sero kana utera hwemasero ayo ane nhamba dzokuti iwe unoda kuchinja nzvimbo dzepakati. sero pane kuti ave nemashoko akapararira pane masero akawanda mumushandi webasa .

Wedzera kana kuderedza nzvimbo dzepamusoro pane pepa

Pa Formatting Toolbar, ita chimwe cheizvi:

1. Dzvanya Wedzera Decimal Button image kuti uratidze mamwe madiresi mushure mekupedzisira
2. Dzvanya Deredza Kuderedza Decimal Button mufananidzo kuti uone zvishomanana madiresi mushure mekupedzisira
3. Muchitokisi E1 chinyora mashoko acho: Mwedzi Yezvokudhura uye divhai muIngeni yeKii pane keyboard.
4. Nokupinda nhamba kuE1 iyo inonzi mu cell D1 inofanira kubviswa pamugumo wesero D1. Uyewo, mutsara muE1 inofanira kupfuurira mucheperi kusvika kurudyi.
5. Kugadzirisa matambudziko aya aya, dhonza sarudza masero D1 neE1 papaspiritsi kuti uonekwe.
6. Dzvanya paIndaneti tab.
7. Dzvanya paKutsvaga Bhokisi reMatsetse pabhoni .
8. Iyo mavara mumasero D1 neE1 inofanirwa ikozvino zvose zviri kuonekwa zvakajeka nemashoko akavhuniwa mumiganhu miviri isina kupera mukati mumasero mashoma.

Tsanangura nzvimbo dzepamusoro dzekuvakwa kwenhamba yemaitiro

1. PaIndaneti yemenyu, chengetera Masekeri, uye ipapo chengetera Nhamba yebhu.
2. Dzvanya Deredza Kuderedza Decimal Button mufananidzo kuti uone zvishomanana madiresi mushure mekupedzisira
3. MuChete list, chekai Nhamba, Mari, Accounting, Percentage, kana Scientific.
4. Mune Decimal nzvimbo mabhokisi, pinda nhamba yezvimbo dzepamusoro dzaunoda kuratidza.
5. Kugadzirisa matambudziko aya aya, dhonza sarudza masero D1 neE1 papaspiritsi kuti uonekwe.
6. Dzvanya paIndaneti tab.
7. Dzvanya paKutsvaga Bhokisi reMatsetse pabhoni .
8. Iyo mavara mumasero D1 neE1 inofanirwa ikozvino zvose zviri kuonekwa zvakajeka nemashoko akavhuniwa mumiganhu miviri isina kupera mukati mumasero mashoma.

Tsanangurai yakagadziridzwa nzvimbo yepamusoro yenhamba

Pa Formatting Toolbar, ita chimwe cheizvi:

1. PaZviyo menyu, chofoza Options.
2. PaIndaneti tab, sarudza Fixed decimal check box.
3. MuInzvimbo Box, nyora nhamba yakanaka kune madijita kusvika kune kodzero ye decimal kana nhamba dzisina kumira kune majeri kusvika kuruboshwe rwema decimal
4. Mune Decimal nzvimbo mabhokisi, pinda nhamba yezvimbo dzepamusoro dzaunoda kuratidza.
5. Kugadzirisa matambudziko aya aya, dhonza sarudza masero D1 neE1 papaspiritsi kuti uonekwe.
6. Dzvanya paIndaneti tab.
7. Dzvanya paKutsvaga Bhokisi reMatsetse pabhoni .
8. Iyo mavara mumasero D1 neE1 inofanirwa ikozvino zvose zviri kuonekwa zvakajeka nemashoko akavhuniwa mumiganhu miviri isina kupera mukati mumasero mashoma.

Semuenzaniso, kana iwe ukapinda 3 muInzvimbo box uye wobva waisa 2834 mune imwe sero, kukosha kuchave 2.834. Kana iwe ukapinda -3 muPaiti yeBhokisi uye wobva waisa 283 mune imwe sero, kukosha kuchava 283000. Click OK. IFIX chiratidzo inowanikwa mubhadha yepamusoro. Pa pepa rekushanda, chengeta kero, uye nyora nhamba yaunoda. Cherechedza Nyaya yawakanyora usati wagadza Fixed decimal check box haibatsiri. Mazano Kuwedzeredza kwenguva pfupi yakasarudzwa decimal sarudzo, faira chirevo chepamusi kana iwe uchinyorera nhamba. Kubvisa mapeji emadhora kubva kumadherere awakatopinda nawo mazvigadziro zvakasarudzwa: Pamutauro Wemutauro weChomwe chengano bhokisi, sarudza Fixed decimal check box. Mune seki isina chinhu, tora nhamba yakadai se10, 100, kana 1 000, zvichienderana nhamba yezvimbo dzepamusoro dzaunoda kubvisa. Semuenzaniso, tape 100 muchitokisi kana nhamba idzi dziine nzvimbo mbiri uye iwe unoda kuvashandura kuti zvive nhamba dzose. Dzvanya Copy Button image (kana chengetedza CTRL + C) kuti ukopi kero yacho kuClipboardboard, uye sarudza masero ane nhamba dzine nzvimbo dzepamusoro.

PaIndaneti menyu, chengetai Nyora Dzakasiyana, uye ipapo tora Dhinda.