Funda ukushintsha izinombolo zokuboniswa kwegama ku-Imeyili hlanganisa ku-Excel

Uma usebenzisa ama- spreadsheets e- Excel kwinqubo yokuhlanganiswa kweposi, abasebenzisi abaningi bavame ukubhekana nobunzima ukufometha amasimu aqukethe ama-decimals noma amanye amanani amanani. Ukuze uqinisekise ukuthi idatha equkethwe emasimini ifakwe ngendlela efanele, umuntu kufanele afake isakhiwo, hhayi idatha efayeleni yomthombo.

Ngeshwa, iZwi alinikezi indlela ongayishintsha ngayo ukuthi zingaki izindawo zasemademeni eziboniswayo uma usebenza nezinombolo. Ngenkathi kunezindlela zokusebenza kulo mkhawulo, isixazululo esihle kakhulu sokufaka inkinobho ensimini yokuhlangana.

Indlela Yokwenza Lo msebenzi Wokushintshwa Kwe-Numerical

Ukuze ucacise ukuthi zingaki izindawo ze-decimal ezizoboniswa ekuhlanganiseni kwe-imeyili yakho, ungasebenzisa ukushintshwa kwe- Numeric Picture Field ( \ # ):

1. Nge-imeyili uhlanganisa idokhumenti enkulu evulekile, cindezela i- Alt + F9 ukubuka amakhodi endle.

Ikhodi yensimu izobukeka okuthize i- "MERGEFIELD" igama lomkhakha "}.

3. Ngemuva kokuphela kokucaphuna okuzungeze uhlobo lwegama lemboni \ # - ungangezi izikhala noma izingcaphuno.

4. Ngokuqondile emva kokushintsha kwenkambu osanda kufaka, thayipha u- 0.0x uma ufuna ukuzungeza inombolo kuya ezindaweni ezimbili zesimanje, i- 0.00x uma ufuna ukuzungeza inombolo ukuya ezindaweni ezintathu zamadesimali nokunye.

5. Uma usuleze inkinobho yakho yasensimini, cindezela u- Alt + F9 ukuze ubonise amasimu esikhundleni samakhodi endle.

Inombolo yakho izovela ehambisana nendawo yedesimali oyicacisayo. Uma ingabonakali ngokushesha, buyiselwa kabusha idokhumenti ngokuyinciphisa kubha yamathuluzi futhi uvule kabusha. Uma inani lensimu lingakabonakali kahle, ungadinga ukuvuselela kabusha idokhumenti noma ukuvala futhi uvule kabusha idokhumenti yakho.