Izinketho zefomethi ezifakiwe ze-Excel

Shintsha inombolo yezindawo ezidumile eziboniswe yiDatha

I-Excel ikuvumela ukuba ulawule inombolo yezindawo zamadesimali eziboniswa idatha.

Izinketho zokubonisa ukuhlaselwa zihlanganisa

• ukuguqula idatha ekhona usebenzisa i-ribbon
• ukubeka inombolo yezindawo zedesimali ngemininingwane ekhona noma kumaseli angenalutho usebenzisa ibhokisi lengxoxo yefomathi yefomathi
• Ukuguqula inombolo ezenzakalelayo yezindawo zedesimali eziboniswe kuwo wonke amaseli kushidi lokusebenzela

Umuntu ngamunye noma amaqembu amangqamuzana kunokuba abe nombhalo osabalalisa phezu kwamaseli amaningi kushidi lokusebenzela .

Ngezinombolo ezisetshenzisiwe kakade ekhasini lokusebenzela, ungakwazi ukwandisa noma ukunciphisa inani lezindawo ezikhonjiswa ngemuva kwephuzu elidumile ngokusebenzisa izinkinobho zebha yamathuluzi. Ungacacisa nenani lezindawo zedesimali ofuna ukuyisebenzisa uma usebenzisa ifomethi yenombolo eyakhelwe ngaphakathi kumaseli noma idatha. Ukuze ube ne-Excel faka amaphuzu wedesimali ngawe, ungacacisa iphuzu elimisiwe lezinombolo zezinombolo.

Khetha iseli noma uhla lwamaseli aqukethe izinombolo ofuna ukushintsha kuzo izindawo ze-decimal. iseli esikhundleni sokuthi umbhalo usakaze ngaphezu kwamaseli amaningi kushidi lokusebenzela .

Khulisa noma wehlise izindawo zamadesimali ekhasini lokusebenzela

Kwifayela yamathuluzi lokufometha, yenza okukodwa kokulandelayo:

1. Chofoza Ukwandisa isithombe se-Decimal Button ukuze ubonise amadijithi amaningi ngemuva kwephuzu lesimanje
2. Chofoza ukunciphisa isithombe se-Decimal Button ukuze ubonise amadijithi ambalwa ngemuva kwephuzu ledesimali
3. Esikhathini se-E1 thayipha umbhalo: Izindleko zenyanga futhi cindezela ukhiye we- Enter ekhibhodi.
4. Ngokufaka idatha ku-E1 ilebula ku-cell D1 kufanele inqunywe ekugcineni kweseli D1. Futhi, umbhalo ku-E1 kufanele uchithelele esitokisini ngakwesokudla.
5. Ukuze ulungise izinkinga ngalawa malebula, donsela amakheli D1 no-E1 kuspredishithi ukuze uwaqokomise.
6. Chofoza kuthebhu yasekhaya .
7. Chofoza inkinobho Yombhalo Wombhalo ku- Ribbon .
8. Amalebula kumaseli D1 no-E1 kufanele manje bobabili babonakale ngokugcwele ngombhalo ophulwe emigqeni emibili ngaphandle kokuchithelwa kumaseli aseduze.

Cacisa izindawo zedesimali ngenombolo yocingo eyakhelwe ngaphakathi

1. Kumenyu yefomathi, chofoza Amaseli, bese uchofoza ithebhu yezinombolo.
2. Chofoza ukunciphisa isithombe se-Decimal Button ukuze ubonise amadijithi ambalwa ngemuva kwephuzu ledesimali
3. Kuhlu lweSigaba, chofoza inombolo, Imali, Ukubika, Amaphesenti, noma Isayensi.
4. Ebhokisini lezindawo ze-Decimal, faka inombolo yezindawo zedesimali ofuna ukuzibonisa.
5. Ukuze ulungise izinkinga ngalawa malebula, donsela amakheli D1 no-E1 kuspredishithi ukuze uwaqokomise.
6. Chofoza kuthebhu yasekhaya .
7. Chofoza inkinobho Yombhalo Wombhalo ku- Ribbon .
8. Amalebula kumaseli D1 no-E1 kufanele manje bobabili babonakale ngokugcwele ngombhalo ophulwe emigqeni emibili ngaphandle kokuchithelwa kumaseli aseduze.

Cacisa iphuzu elimisiwe lezinombolo zezinombolo

Kwifayela yamathuluzi lokufometha, yenza okukodwa kokulandelayo:

1. On the Amathuluzi imenyu, chofoza Izinketho.
2. Kokubekwe Hlela, khetha ibhokisi lokuhlola elimisiwe le-decimal.
3. Ku-Ibhokisi lezindawo, faka inombolo enhle yamadijithi ngakwesokudla kwephoyinti le-decimal noma inombolo engafanele yamadijithi ngakwesokunxele kwephoyinti ledesimali
4. Ebhokisini lezindawo ze-Decimal, faka inombolo yezindawo zedesimali ofuna ukuzibonisa.
5. Ukuze ulungise izinkinga ngalawa malebula, donsela amakheli D1 no-E1 kuspredishithi ukuze uwaqokomise.
6. Chofoza kuthebhu yasekhaya .
7. Chofoza inkinobho Yombhalo Wombhalo ku- Ribbon .
8. Amalebula kumaseli D1 no-E1 kufanele manje bobabili babonakale ngokugcwele ngombhalo ophulwe emigqeni emibili ngaphandle kokuchithelwa kumaseli aseduze.

Isibonelo, uma ufaka 3 ebhokisini Yezindawo bese uthayipha u-2834 esitokisini, inani lizoba ngu-2.834. Uma ufaka -3 ku-Places box bese uthayipha 283 esitokisini, inani lizoba ngu-283000. Chofoza OK. I-Indicator FIX ivela kubha yomumo. Ekhasini lokusebenzela, chofoza iseli, bese uthayipha inombolo oyifunayo. Qaphela Idatha oyifakile ngaphambi kokuthi ukhethe ibhokisi lokuhlola elimisiwe le-decimal alithintekile. Amathiphu Ukwedlula okwesikhashana okukhethwa kukho okukhethiwe, thayipha iphuzu eliyisimanje uma uthayipha inombolo. Ukuze ususe amaphuzu wedesimali kusuka ezinombeni osuvele uzifakile ngezinhlawulo ezihleliwe: Ku-Hlela ithebhu yebhokisi lezinketho zezinketho, cisha ibhokisi lokuhlola elimisiwe le-decimal. Esikilinikweni esingenalutho, thayipha inamba efana no-10, i-100, noma i-1,000, kuye ngokuthi inani lezindawo zedesimali ofuna ukususa. Isibonelo, thayipha u-100 esitokisini uma izinombolo ziqukethe izindawo ezimbili zedesimali futhi ufuna ukuziguqula zibe izinombolo eziphelele. Chofoza isithombe se-Copy Button (noma cindezela i-CTRL + C) ukuze ukopishe iseli ku-Clipboard, bese ukhetha amaseli aqukethe izinombolo ngezindawo zedesimali.

KuMenyu yokuHlela, chofoza okuthi Namathisela Okukhethekile, bese uchofoza Ukunyuka.