Xa usebenzisa i- Excel spreadsheets kwi-imeyile yokuhlanganisana nenkqubo, abaninzi abasebenzisi basebenza ngokubaluleka kokufomatha imimandla equlethe i-decimals okanye ezinye ixabiso lamanani. Ukuqinisekisa ukuba idatha equlethwe kwimida ifakwe ngokuchanekileyo, omnye kufuneka afake ifom, kungekhona idatha kwifayile yomthombo.
Ngelishwa, iLizwi alinakukunika indlela yokuba utshintshe ukuba zingaphi indawo zokugqibela eziboniswayo xa usebenza ngamanani. Nangona kukho iindlela zokusebenza malunga nalo mda, isisombululo esihle kakhulu kukuquka umtshintshi kwintsidi yokudibanisa.
Indlela yokwenza lo msebenzi we-Switch Switch
Ukucacisa ukuba zingaphi iindawo zokugqibela eziza kubonakalisa kwi-imeyile ye-imeyile yakho, ungasebenzisa iNguqulelo yeSithombe seSithombe seTshintsho ( \ # ):
1. Ngeposi kufuneka udibanise uxwebhu oluvulekile, cindezela Alt + F9 ukujonga iikhowudi zentsimi.
2. Inkokhelo yentsimi iya kubheka into efana ne "MERGEFIELD" igama lensimu "}.
3. Ngokukhawuleza emva kokugqibela ukucaphula malunga negama lomhlaba wendawo \ # - ungafaki izikhala okanye izicaphuno.
4. Ngokuzenzekelayo emva kokutshintsha kwintsimi ongena kuyo, thayipha i- 0.0x ukuba ufuna ukujikeleza inamba ukuya kwiindawo ezimbini zokugqibela, i- 0.00x ukuba ufuna ukujikeleza inombolo ukuya kwiindawo ezintathu zokugqibela kunye nokunye.
5. Emva kokuba ukongeza ukutshintsha kwintsimi yakho, cinezela i- Alt + F9 ukubonisa indawo esikhundleni sekhowudi zefowuni.
Inombolo yakho iya kubonakala ijikelezwe kwindawo ephakamileyo oyicacisayo. Ukuba ayibonakali ngokukhawuleza, hlaziya kwakhona umqulu ngokuwunciphisa kwibar yomthamo kwaye uvule kwakhona. Ukuba ixabiso lentsimi lingasayi kubonakalisa ngokuchanekileyo, ungadinga ukuhlaziywa kwakhona kwiphepha okanye uvale kwaye uvula kwakhona umqulu wakho.