Phunzirani Kusintha Mawonedwe a Mawu Numeri mu Mail Gwirizanitsani ku Excel

Mukamagwiritsira ntchito Excel spreadsheets mu makalata ophatikizira makalata, ogwiritsa ntchito nthawi zambiri amagwiritsa ntchito zovuta kupanga mapepala omwe ali ndi ziwerengero kapena ziwerengero zina. Kuonetsetsa kuti deta yomwe ili m'mindayi imayikidwa molondola, wina ayenera kupanga fomuyo, osati deta mu fayilo yoyamba.

Mwamwayi, Mawu samakupatsani njira yoti musinthe malo angapo omwe amasinthidwa pamene akugwira ntchito ndi manambala. Ngakhale pali njira zogwirira ntchito kuzungulira izi, njira yothetsera yabwino ndikuphatikizira gawolo.

Mmene Mungagwiritsire Ntchitoyi Kusintha kwa Numeri

Kuti mudziwe malo angapo omwe amasinthidwa mu mauthenga a Mawu anu, mungagwiritse ntchito Numeric Picture Field Switch ( \ # ):

1. Ndi makalata aphatikize chikalata chachikulu chotseguka, dinani Alt + F9 kuti muwone ma fomu.

2. Mndandanda wamunda udzawoneka ngati {MERGEFIELD "fieldname"}.

3. Pambuyo pake mapeto atchulidwa kuzungulira fomu ya dzina # # - musawonjeze malo kapena ndemanga.

4. Pambuyo pa munda mutasintha kumene, lembani 0.0x ngati mukufuna kulembetsa nambalayo mpaka malo awiri, 0.00x ngati mukufuna kulembera nambalayi ku malo atatu otsiriza ndi zina zotero.

5. Mukatha kuwonjezera masewera anu, yesani Alt + F9 kuti muwonetse minda mmalo mwa ma fomu.

Nambala yanu idzawonekera pozungulira malo omwe mumalongosola. Ngati sichiwonetseratu nthawi yomweyo, tsambutsani chikalatacho pochichepetsera ku toolbar ndi kutsegula. Ngati mundawu ukuwerengabebe sungasonyeze molondola, mungafunike kubwezeretsanso chikalata kachiwiri kapena kutseka ndikutsegulanso chikalata chanu.