Paunenge uchishandisa Excel mahwendefa mumusana kuungana, vatengi vese vanoshandisa nguva yakaoma mukugadzirisa mafungiro ane zvigadziro kana zvimwe nhamba dzamazita. Kuti uone kuti data iri muminda inowanikwa nenzira yakarurama, mumwe anofanira kufambisa munda, kwete data iri mufaira.
Zvinosuruvarisa, Shoko haritauri nzira yekuti iwe uchinje matanho mangani ekugadziriswa anowanikwa kana uchishanda nenhamba. Nepo kune nzira dzekushanda zvakakomberedza izvi, mhinduro yakanakisisa ndeyokuisa shanduko mumunda wekubatanidza.
Nzira Yokuita Nayo Basa Rokuchinja Nhamba
Kuti ujekese matanho mangani ekupedzisira ekuratidza muShoko reMeyili yako, unogona kushandisa Numeric Picture Field Switch ( \ # ):
1. Nemaepa ichisanganise rugwaro rukuru rwakazaruka, shandisa Alt + F9 kuti uone magwaro emunda.
2. Nhamba yemunda ichaona chimwe chinhu se "MERGEFIELD" field name "}.
3. Pakupedzisira kwekupedzisira kudzokorora kumativi ose emumunda wezita type \ # - usawedzera nzvimbo kana zvinyorwa.
4. Pamberi pekushandura kwemunda wawakangopinda , tanga chinyorwa 0.0x kana uchida kukomberedza nhamba kusvika kune dzimwe nzvimbo mbiri, 0.00x kana iwe uchida kukomberedza nhamba kusvika kune matatu nzvimbo dzepamusoro nezvimwe zvakadaro.
5. Kana wapedza kuwedzera shanduko yako, shandisa Alt + F9 kuti ione masimi pane nzvimbo dzemasimi.
Nhamba yako ichaonekwa yakapoteredzwa kune nzvimbo yekusimudza yaunotsanangura. Kana iyo isingaratidzi pakarepo, zorora patsva dhidhiyo kuburikidza nekuideredza iyo kubhairidzi uye kuzarura zvakare. Kana munda wacho uchiri kukosha haugoni kuratidza zvakanaka, unogona kunge uchivandudza dhidhiro zvakare kana kuti yepedyo uye ugozarurazve gwaro rako.